Originally Posted by rvg72
Originally Posted by fozzy71
'cluster' did nothing. It may have spit out some error code that I didnt bother reading.
ok, that's what I thought would happen. I could write a cluster script that would do what you had intended. I'll mess around with that once I get these other things taken care of.
Oops, my mistake.
Yes, CLUSTER alone does nothing to a database that has never been clustered before.
After the first successful cluster (or after the indexes have been specified) - the command CLUSTER re-clusters any tables that have been clustered before (or specified).
I wrongly assumed it would automatically use the one index if a table had only one to choose from.