Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizable expressions
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00517247
Message ID:
00517388
Views:
20
I tried your code and got partial optimization. I then created a DBC and added the table to it. Ran SDT Explorer to create all the extensions. Then ran the following code to have SDT reindex. I still got partial optimization on the query.
close all
open database gdtest
set database to GDTest
set procedure to program()
oMeta = NewObject("DBCXMgr", "DBCXMgr.VCX")
oMeta.SetDataBase(dbc())
llRetval = oMeta.oSDTMgr.Reindex('', .f., .t.)
close table all
sys(3054,1)
select ctest from test where mkup() = 'A' into cursor curtest
sys(3054,0)
close tables all
release procedure program()
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform