What will happen if i create a clustered Index on a table? RRS feed

  • Question

  • I have read so many articles on Indexing in SQL Server. In my workplace i created indexes no.of times, but i need information on  basics like how it saved and how it arrange the table or Is this maintain separate copy of table ?

    suppose i have a table with three columns, one column is primary key column so clustered index created on the table. my concern is, How clustered index will be useful to make fast retrieval ?

    Please reply on step by step, so others or me understand clearly.

    Tuesday, October 29, 2019 10:29 AM

All replies