What is Index awareness?

Showing Answers 1 - 1 of 1 Answers

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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions