Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
Hi Denis
What are you trying to do? How many printer records can you have in this table?
>Hi Again...
>I try to do next way
>
>INDEX ON "1"+UPPER(Description) TAG Test1
>
>SELECT * FROM table WHERE "1"+UPPER(Description) like "1%HP%DRUCKER"
>
>SYS(3054) show result about Test1 and Deleted Tags using in the Rushmore optimization, but optimization level still is "partial"
>
>And... time of exec query realy looks not good....
>
>
>>Hello,
>>
>>a LIKE condition which starts with % cannot be optimized.
>>
>>Regards
>>Christian
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only