document.body.ondragstart = "return false";document.body.onselectstart = "return false"; microsoft dynamics ax interview questions: What is the difference between indexhint and index? How many types of indexes are there?

Tuesday, November 30, 2010

What is the difference between indexhint and index? How many types of indexes are there?

Normally when quering if we use index it shows that the retrieving should happen based on the field used in the index, but here irrespective of this field if any best index is available DB chooses it and performs query, but if we use the index hint than DB id forced to use the specified index instead of any one.

No comments:

Post a Comment