Index:
When we index in select statement it implies that the declare index field should behave as an order by and is optional the database to use. database can use its own preferences.
Index Hint:
Index hint in select statement will force the database to choose index for fetching data whether it is correct or not.
When we index in select statement it implies that the declare index field should behave as an order by and is optional the database to use. database can use its own preferences.
Index Hint:
Index hint in select statement will force the database to choose index for fetching data whether it is correct or not.
No comments:
Post a Comment