What is Index awareness?

  • Interview Candidate
  • 3
  • 7601

Showing Answers 1 - 3 of 3 Answers

sreya_1234

  • Nov 12th, 2007
 

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval. When you set up index awareness in Designer you tell Designer which database columns are primary and foreign keys. This can have a dramatic effect on query performance.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions