My select quaery order by takes 65 minutes . When I create index in the same order, select query does not use the indexs & goes for sorting. It uses temp tablespace - So it affects the performance. IIs there a solutions for the above problem ? I appreciate you early solution/advise Thanks Selva