Although
in most cases the query optimiser will pick the appropriate index for a
particular table based on statistics, sometimes it is better to specify the
index name in your SELECT query. For example, consider the following
Notice the additional "WITH"
clause after FROM. This example is specific to MS SQL Server. Every database
use different syntax for specifying this value and they are quite different
from each other. Refer to your RDBMS documentation for details.
No comments:
Post a Comment