Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

index option Expand / Collapse
Author
Message
Posted Tuesday, December 23, 2008 5:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 2, 2012 5:35 PM
Points: 21, Visits: 169
What are index options that can be applied to clustered index but not to nonclustered index.
Post #625094
Posted Tuesday, December 23, 2008 5:28 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
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/
Post #625101
Posted Tuesday, December 23, 2008 5:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 2, 2012 5:35 PM
Points: 21, Visits: 169
been asked in the interview.
Post #625104
Posted Tuesday, December 23, 2008 7:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 9:13 PM
Points: 190, Visits: 637
Included columns are only for non clustered indexes but not for clustered index, i believe.
Post #625139
Posted Tuesday, December 23, 2008 7:42 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
They were probably talking about query hints to force the use of a particular index.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #625143
Posted Tuesday, December 23, 2008 8:04 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
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!


Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #625151
Posted Tuesday, December 23, 2008 8:17 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
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.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #625156
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse