locked
Does Creation of Index Create additional records RRS feed

  • Question

  • I have a table with 70 columns having around 20 millions of records.

    I want to create non clustered index on around 6 columns.

    One of my friend suggested that the creation of index will create same number of records that table has (means it will create around additional records).

    I have few questions:

    1. Does this is true?

    2. If yes where the records will be stored?

    3. Does creation of indexes on table creates additional records?


    Deepak Talele Ph: 91-9158413830 Email: deepak_talele@hotmail.com, deepak_talele@yahoo.com

    Monday, May 2, 2016 6:21 PM

Answers

  • 1) It's true.

    2) Records will be stored in specific index data pages (index structure).

    3) Non-clustered index create additional records (index data pages) but no in table (heap) itself.

    See: http://voluntarydba.com/post/2014/01/07/Clustered-vs-Nonclustered-Index-Internal-Structures.aspx

    Tuesday, May 3, 2016 12:11 AM