Hi I have a query having 93% of cost at sort operation, what is the best practice for fastening Order By clause? Indexes on order by columns have an effect on the operation? Thanks.
Indexes can make sort operations run faster. It does depend on what is being sorted, how many rows, what the rest of the query looks like etc. Try it. If it doesn't work, capture the execution plan and post the query and execution plan here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" - Theodore Roosevelt