December 23, 2008 at 5:10 pm
What are index options that can be applied to clustered index but not to nonclustered index.
December 23, 2008 at 5:28 pm
mesql (12/23/2008)
What are index options that can be applied to clustered index but not to nonclustered index.
Well, one that comes to mind is included columns.
Just out of curiosity, why?
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
December 23, 2008 at 5:33 pm
been asked in the interview.
December 23, 2008 at 7:25 pm
Included columns are only for non clustered indexes but not for clustered index, i believe.
December 23, 2008 at 7:42 pm
They were probably talking about query hints to force the use of a particular index.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
December 23, 2008 at 8:04 pm
RBarryYoung (12/23/2008)
They were probably talking about query hints to force the use of a particular index.
Hey How did you know... were you running the interview! :w00t:
Craig Outcalt
December 23, 2008 at 8:17 pm
SQLBOT (12/23/2008)
RBarryYoung (12/23/2008)
They were probably talking about query hints to force the use of a particular index.Hey How did you know...
Honestly? I felt a disturbance in the Force.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply