On June 6, 2006 07:59 am, "Carlos Oliva" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
