Yep, the Rushmore optimizer likes this one! try this:
close table all
clear
create table test ( ctest c(20), cfld1 c(10) )
insert into test (ctest, cfld1) values ('abcdefg', 't1')
insert into test (ctest, cfld1) values ('bbcdefg', 't1')
insert into test (ctest, cfld1) values ('cbcdefg', 't1')
insert into test (ctest, cfld1) values ('aacdefg', 't1')
insert into test (ctest, cfld1) values ('agbcdefg', 't1')
index on mkup() tag Tagtest
sys(3054,1)
select test
select ctest from test where mkup() = 'A' into cursor curtest
brow
sys(3054,0)
close table all
delete file test.dbf
delete file test.cdx
function mkup
return upper(ctest)
>>If I index a file on a function like
>>
>>index on SqueezeDesc() tag Xdesc
>>
>>then query optimizations take advantage of the expression ie.
>>
>>select * from xFile where squeezedesc() = 'ABC' (Fully optimized)
>>
>>After I used STD to reindex the table the expression is no longer Rushmore optimized. What is a workaround for this problem?
>
>I did not think that could ever be optimized. What does KEY(n) return? Does it return SqueezeDesc()?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement