I have a table with a number of columns. I perform Select * from table order by a,b There is an index on a,b which is clustered (as well as indexes on a and b alone). I have issued the cluster and anyalze commands. Nevertheless, PostgreSQL performs a Sequential Scan on the table and then performs a sort.
Am I missing something? Jonathan Blitz