>I have a select statement which USED to be optimized, but the client added a filter to the index expression. How do I modify my SELECT to accommodate the filter?
>
>The index is UPPER(Job.External) and the filter is .NOT. EMPTY(External)
>
>My old select is something like:
>SELECT blah blah blah FROM LinkJob INNER JOIN External ;
>ON LinkJob.External = UPPER(Job.External) ;
>blah blah blah
>INTO CURSOR TQuery
>
>TIA
You can't. Rushmore will not use filtered indeces.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer