You know what? Its an awesomely helpful video. The way you explained absolutely clears doubts in mind. Great job. I don't know how come only 72 people liked this video.
Great Video ! i am working with big table and the important it's the response time... in this case the size of the dtabase its not a problem i did create a non-cluster indexes and the performance its increible good ! in this case i have 5 important queries in this table, for example... case 1: selec all from person where age=@age.... i did create a non cluster with the age and the response its great ! but for example i have the sample table but this query selec all from person where age=@age and city=@city... what its the better solution creat a NEW indexes with the TWO fields or only including in the first the two parameters its the better solution ?
Hi, I have a question. I run query with only nonclusered index on LastAccessDate and Id : Select DisplayName, Age from dbo.Users where LastAccessDate > '7/1/2010' Order by LastAccessDate; When I look Estimated Execution plan i don't see Index Seek + Key Lookup, but only Idex scan. Does it have something to with MS SQL Sever version, version I'm runing is 14.0.1000.169 (X64).
You know what? Its an awesomely helpful video. The way you explained absolutely clears doubts in mind. Great job. I don't know how come only 72 people liked this video.
Thanks, glad you liked it!
I just like the video and just subscribed to the channel.
Because SQL Server tuning is hard.
Brent Ozer = 'Awesome' ... Always !!!!
Superb Explanation of Non-ClusterIndex
Thanks!
You had me at "run the narrower query"
A notice: oracle enteprise costs $47000 per processor, not core
Great stuff.
You da man!
Great Video ! i am working with big table and the important it's the response time... in this case the size of the dtabase its not a problem i did create a non-cluster indexes and the performance its increible good ! in this case i have 5 important queries in this table, for example... case 1: selec all from person where age=@age.... i did create a non cluster with the age and the response its great ! but for example i have the sample table but this query selec all from person where age=@age and city=@city... what its the better solution creat a NEW indexes with the TWO fields or only including in the first the two parameters its the better solution ?
For specific question, head on over to DBA.StackExchange.com.
Hi, I have a question. I run query with only nonclusered index on LastAccessDate and Id :
Select DisplayName, Age
from dbo.Users
where LastAccessDate > '7/1/2010'
Order by LastAccessDate;
When I look Estimated Execution plan i don't see Index Seek + Key Lookup, but only Idex scan.
Does it have something to with MS SQL Sever version, version I'm runing is 14.0.1000.169 (X64).
Alekola - keep watching this and part 3 to understand why.