Join Martin Guidry for an in-depth discussion in this video Indexing tips, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- Now I'd like to give you a few tips…on designing indexes in SQL Server in 2012.…We typically want to index all foreign keys,…any field that's used in a join;…the join can typically run much quicker…if all fields used in the join have an index.…We typically see good benefit from indexing columns…that are commonly used in the…WHERE, ORDER BY, or GROUP BY clause…in a SQL statement.…These are all clauses that are commonly used in reports…so if you have a lot of reports…that always ORDER BY a certain column…it would probably benefit you…to create an index on that column.…
You should also be aware of how…the Query Optimizer chooses indexes…to use on a table.…It will typically only use an index on a field…if that field stands alone.…Let's look at an example…where a field does not stand alone.…Here we're running the YEAR function…on a column called (myDate)…and looking for any situation where the YEAR is >= 2012.…In this example the (myDate) does not stand alone;…the (my Date) is part of a function.…
And therefore the Query Optimizer…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- 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.