Question about Index usage:
If I create a nonclustered index like
Where it is created by
LastName ASC and
Age ASC, and there is clustered index on
Now if I run a query
Select Age from dbo.user where Age > 10
Would the execution plan use "IX_LastName_Age" or will it scan from Clustered Index?