Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
suriyarupa
Starting Member
19 Posts |
Posted - 2013-05-13 : 07:06:49
|
I have a table with lakhs of data. Now I want to create index in this table. So this index is applicable for old data also? or It will maintain indexes for new data only? Please clear this doubt. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-13 : 07:16:08
|
Index will be built using entire data of the table including the existing data unless the table is partitioned and index is created on one or more specific partitions. Also Index should not be a filtered index in which case it will exclude some set of data based on the defined filter.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|