In message <5.1.0.14.0.20030117164213.02de6e90@[158.36.132.22]>, Svein
Erling Tysvaer <svein.erling.tysvaer@...> writes

>Hello Andrew!

>I assume IDX_DOCDATE is referring to 'and d.DocDate < CURRENT_TIMESTAMP',
>something which in many cases will refer to most records. Such an index is
>futile to use, get rid of it in your plan by changing to 'and (d.DocDate <
>CURRENT_TIMESTAMP or 2=0)'
>
>(it doesn't matter what numbers you choose, just
>something that always evaluates to false - we're just trying to limit the
>optimiser in choosing indexes).

Can you elaborate on that, please? How does this help?

>
>Set

--
Pete Clark