General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
My guess is that you are operating with DELETED ON and do not have a TAG on DELETED().
The usual warning applies - "partial" may be better in THIS case.
>Hi
>
>I have a table indexed on PID+DToS(Date) and when I issue the following query it reports that it is only partially optimized.
>
>Select * From myTable Where PID+DToS(Date)="!!!!!#"
>
>I expected it to report that is was fully optimized. Can someone explain why it is only partially optimized?
>
>It also reports partial optimization when I add the date as follows:
>
>Select * From myTable Where PID+DToS(Date)="!!!!!#20021225"
>
>Thanks
>Simon
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