HI, i have created a table with columns A and B. A is indexed column. and use following queries
1. select * from Test where A = '<something>' 2. select * from Test where A = '<something>' order by B #1 is fast as it uses default sorting of indexed column A. But #2 is slow. Do you think creating index on B will speed up #2 query ? i tried that as well and no luck. are there any ways to improve the performance of #2 ? please advise. Thanks
