Index awareness

Index awareness is a feature that will help the IDT use key columns while generating SQL queries to speed up data retrieval. The main idea of this feature is to use the available database index. A query based on an indexed database column will retrieve data faster than a normal column. To make it easier, let's take an example first and perform the following steps:

  1. Open the NorthWind Business layer and then navigate to the Business Layer tab from the left panel.
  2. Create a new Status Name dimension under the Orders folder.
  3. Go to the Queries tab from the left panel and create the following query:
    Index awareness
  4. Then click on View Script to display the ...

Get Creating Universes with SAP BusinessObjects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial