Re: How is optimization calculated on a query

You might consider adding to Jonathon's good suggestions by making a multikey index: on c1, then c2. It should be able to do any index-only query plan.

Let us know how it all works out.....

ricke1_at_my-dejanews.com wrote in message <6uomu3$uf5$1_at_nnrp1.dejanews.com>...
>Thanks for the hint. I tried it and it didn't seem to have any effect on
my
>execution plan. I do sometimes get an index scan on a 1 date constraint
and I
>have gotten in the past index scans on multiple dates without the to_date.
I
>am getting the correct number of rows selected.
>
>I would think that doing a select --+ index would force an index scan if
>possible and it doesn't.
>
>Thanks in advance for any other suggestions.
>-Rick
Received on Fri Oct 02 1998 - 08:20:48 CDT