On Sun, 22 Nov 2009, Jonathan Blitz wrote:
> 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.
Did you analyse *after* creating the index and clustering, or before?
Matthew
--
[About NP-completeness] These are the problems that make efficient use of
the Fairy Godmother. -- Computer Science Lecturer
