April 19, 2013 at 4:46 pm
I just finished learning about clustered and nonclustered indexes and I was wondering a few things since I doubt I fully grasp these concepts yet. With nonclustered indexes, you can make them convering indexes by adding filters and INCLUDE column to make them as efficient as clustered indexes, so why use clustered indexes? Or is it because you can only use one clustered index per table, that you need to use nonclustered indexes? Again, I just finished learning these concepts the past few days so I'm trying to fully understand them.
April 19, 2013 at 4:49 pm
Here are a few resources that would be of benefit to you in trying to learn about indexes
http://www.sqlservercentral.com/stairway/72399/
And
http://www.sqlservercentral.com/articles/Indexing/68439/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 4:51 pm
Oh wow thanks for those links.
April 19, 2013 at 4:52 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2013 at 5:12 pm
While we are on the topic, "seek" and "lookup" seem like the same thing, at least in terms of their syntax and what they're trying to accomplish. I'm assuming with a seek, you can do multiple rows where with a lookup you can only do one row/column.
April 20, 2013 at 5:00 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
Seek - navigation down the b-tree of an index to locate a row or the start or end of a range of rows.
Lookup - single-row seek on the clustered index to fetch the rest of the columns necessary for the query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply