Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

Using force index hint - SQL Server

Apr 22 2012 12:00AM by Paresh Prajapati   

I wrote about my previous just learned tips about covering index and will publish my future post for the detail understanding it. We should generate index statistics and index usage report periodically, so we can have more idea of the index utilization. Sometime we require different indexes other than query optimizer used for the execution for the best performance. You can read my earlier post for the index play here. Here i want to demonstrate same.

How can we use different indexes other that query optimizer used for execution? You can force the indexes to be used with Index Hint.

Continue Reading...

Tags: sql, sql server, ms sql, ms sql server, #SQL Server, #sql, database, sql server general, SQL Scripts, Index, Hint, Index Hint, Query optimizer

Paresh Prajapati
6 · 23% · 7533


Your Comment

Sign Up or Login to post a comment.

"Using force index hint - SQL Server" rated 5 out of 5 by 5 readers
Using force index hint - SQL Server , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]