On June 6, 2006 07:59 am, "Carlos Oliva" <carlos@pbsinet.com> wrote:
> We are conducting a simple test to asses if the optimizer ever uses the
> index. The table has several columns and the select statement is as
> follows: select * from ord0007 order by prtnbr, ordschdte desc. The
> index that we added is "ord0007_k" btree (prtnbr, ordschdte). Prtnbr is
> numeric(10,0) not null, and ordschdte is date.
You have to "order by prtnbr desc, ordschdte desc" to have the index used
the way you want. You can re-order in an outer query if you need to.
--
Alan
