prakash

• 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