Groups > comp.databases.ms-sqlserver > #1906

Engine Tuning Advisor recommending non-clustered index on clustered PK columns

X-Received	by 10.182.5.104 with SMTP id r8mr28301674obr.19.1429029752686; Tue, 14 Apr 2015 09:42:32 -0700 (PDT)
X-Received	by 10.182.116.164 with SMTP id jx4mr135080obb.27.1429029752614; Tue, 14 Apr 2015 09:42:32 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!m20no3460606iga.0!news-out.google.com!db6ni16128igc.0!nntp.google.com!m20no3460604iga.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 14 Apr 2015 09:42:32 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=15.219.169.71; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
NNTP-Posting-Host	15.219.169.71
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<5b308c23-aca5-4c1f-89c6-3e578aaf2fd1@googlegroups.com> (permalink)
Subject	Engine Tuning Advisor recommending non-clustered index on clustered PK columns
From	Mark D Powell <markp28665@gmail.com>
Injection-Date	Tue, 14 Apr 2015 16:42:32 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1906

Show key headers only | View raw

A recent Database Engine Tuning Advisor run on a SQL Server 2008 R2 RTM system has several recommendations that puzzle me because the recommendation is for a two column non-clustered index on the same two columns that are the clustered PK.  In one case there are only two other columns consuming a total of 5 bytes on the row so I just cannot see any valid reason for this recommendation.
- -
There is a index reorganization job I added to the system that runs every Sunday but statistics update is left to SQL Server.  
- -
Does anyone have a good idea of what would cause these recommendations?
- -
-- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Engine Tuning Advisor recommending non-clustered index on clustered PK columns Mark D Powell <markp28665@gmail.com> - 2015-04-14 09:42 -0700
  Re: Engine Tuning Advisor recommending non-clustered index on clustered PK columns Erland Sommarskog <esquel@sommarskog.se> - 2015-04-14 20:29 +0200
    Re: Engine Tuning Advisor recommending non-clustered index on clustered PK columns Mark D Powell <markp28665@gmail.com> - 2015-04-15 09:59 -0700
  Re: Engine Tuning Advisor recommending non-clustered index on clustered PK columns rja.carnegie@gmail.com - 2015-04-15 20:40 -0700

csiph-web