I'm creating a view with order by columnname desc if I see the explain plan it will take around 10 mins. But I create same view without order by it will run less than 10 seconds.. I also created index for that column and used index, parallel hints still it's not improved how to improve the performance of the view with order by clause…