Hacker Newsnew | past | comments | ask | show | jobs | submitlogin



That's not the same as a clustered index, it just does a one-time rearrangement of the table’s current contents; you have to run it after each change effecting the index to simulate a clustered index (with stable PKs, and the PK index, that would be after each insert, I think.)

You get closer to a clustered index (at the cost of more storage, but the benefit that you can have more than one on a table) with an index using INCLUDE to add all non-key columns in the index.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: