Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning indexing a table having million of records RE: indexing a table having million of records
TEJABI
Old Hand
Points: 368
More actions
August 4, 2014 at 3:19 am
#1734765
Are u really need index for all columns?. if u not needed for columns ,remove that columns then get improvement .
if u needed all columns then go for covered index .