Re: Sorting problems oracle 9i

In my opinion,

What ever query you write, you have to scan the entire table. I can see 3 possible solutions here.

1. If the table is less write intesive and more read intesive, alter this table as Index organized. or
2. Create an Index on price field or
3. Maintain a separate small table with three rows (top three prices) and write a trigger to update this table on Insert / update / delete from the original table.

Bechmark these solutions and decide which one suits you best. Regards
Vaishnavi Received on Wed Dec 29 2004 - 11:10:19 CST