I would to, but the database is close to the 2 gig limit. rich ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 1:26 PM Subject: [RBASE-L] - SV: Retrieving rows of a table using a partial index
I am out of line here since I dont know the implication for speed, but what I would have done is to create a computed column (sget(matchkey,5,1)) and make that column my second index. Gunnar Ekblad -----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r rich Jasinski Skickat: den 24 september 2003 18:49 Till: RBASE-L Mailing List �mne: [RBASE-L] - SV: Retrieving rows of a table using a partial index I know that will work but is it using the 16 char index or the 5 char. I want to use the 5 char for speed. rich ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 12:44 PM Subject: [RBASE-L] - SV: Retrieving rows of a table using a partial index Have you tried : Where matchkey like 'abcde%' Pending of course your setting for quate and many Gunnar Ekblad -----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r rich Jasinski Skickat: den 24 september 2003 18:35 Till: RBASE-L Mailing List �mne: [RBASE-L] - Retrieving rows of a table using a partial index I have a table that has a column called matchkey that is 16 char long text. I have indexed the full column length. I have also indexed it with only the first 5 chars. How do I tell the select clause to use the 5 character index instead of the 16 char index. rich
