Join Joey D'Antoni for an in-depth discussion in this video Choosing a PK or clustered index key, part of SQL Server Performance for Developers.
- [Instructor] Beginning our next chapter of Indexing,…we're going to talk about choosing a primary key…and a clustering key.…Frequently these things are the same…and we'll talk about the benefits of that,…but before we get into this topic…I'd like to talk a little bit about the differences between…clustered indexes and non-clustered indexes.…This is something that's a little bit unique to SQL Server.…Some other databases have similar functionality,…particularly Sybase,…but if you're coming from an Oracle or MySQL background…it may be a little bit different to you.…What a clustered index does is…stores the entire table's pages…in the order of the clustering key.…
When we talk about a clustered index it represents all…of the data that's stored in the entire table.…This is really good for things like…doing order by or index range scans…and it tells SQL Server how to order those pages…and it uses a B-tree structure to do that.…And really, when we talk about indexes,…specifically we look for two types of operations.…
- Query execution
- How to read an execution plan
- What not to do with SQL Server
- Why cursors are bad
- Why scalar UDFs are expensive
- Datatypes and design
- What is a columnstore index?
- Transaction isolation
Skill Level Intermediate
1. Query Execution
2. What Not to Do with SQL Server
3. Datatypes and Design
4. Temporary Objects
7. Isolation Levels
Next steps2m 15s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.