I need to add an index tag to a VFP table (part of VFP database). The field is type C, 40. I am always concerned that if I create an index on the entire field (of 40 char length), it will slow down the opening/updating/maintaining the table. I thought that maybe I should create an index tag only on the first 20 characters. Like
index on upper(substr(MYFLD,1,20)) tag MYTAG
Is it better? Or by adding the SUBSTR() expression I am loading the index tag anyway? The table, by the way, will have max of about 10,000 records.
Thank you for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham