Index Awereness

How to create index awareness in Universe?

Questions by sandwbo

Showing Answers 1 - 1 of 1 Answers


  • Oct 22nd, 2011

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval. The objects that you create in the universe are based on database columns that are meaningful to an end user. For example, a Customer object retrieves the field that contains the customer name.

In this situation, the customer table typically has a primary key (for example, an integer) that is not meaningful to the end user, but which is very important for database performance. When you set up index awareness, you tell Universe Designer which database columns are primary and foreign keys

  Was this answer useful?  Yes

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