Re: SQL Query

Oradba Linux wrote:
> Select * from orders where load_id = 174659 order by order_id ;
>
> select * from orders where load_id = 174659 order by order_dt;
>
> I have similar queries. This table has about 19mil rows. Statistics are
> current. Order_id is the primary key. The index exists on load_id. The
> first one does a index full scan on order_id and second one does a index
> range scan on load_id. There is no index on order_dt.
> If needed i can post the explain plans and stats details from
> user_tables/user_indexes. I am wondering why the index on load_id is not
> chosen in the first SQL statement.

Please let me know when u get a solution

regards Received on Wed Jan 17 2007 - 22:59:04 CST