CREATE TABLE TEST(ITEM VARCHAR(20) NOT NULL PRIMARY KEY, VAL BLOB SUB_TYPE BINARY);
SELECT VAL FROM TEST WHERE ITEM = '...';
INSERT INTO TEST(ITEM, VAL) VALUES('...', ...);
SELECT FIRST 1 RIGHT(ITEM, 8) FROM TEST WHERE LEFT(ITEM, 8) = '...' ORDER BY
ITEM DESC;
These are sql statements that I will use.
Is it better to create indexes for this table?
Someone told me that PRIMARY KEY field is automatically indexed internally.
But I am not sure if it is true or not. Can anyone verify this?
thx
