Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Question about included columns in nonclustered indexes: Where exactly are they stored? RE: Question about included columns in nonclustered indexes: Where exactly are they stored?
Kristian Ask
SSC Eights!
Points: 907
More actions
November 16, 2012 at 8:13 am
#1559832
I know it's an old topic but how is included columns affecting memory footprint? Some say higher use to put index in.memory cache. Some say lower since less pages are read and cached since it is in the index.
K