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:

   

4. Then click on View Script to display the following SQL code generated by this query:

   

We can see the relation between the Orders, Customers, and Orders Status tables in the following figure:

As we can see, we have a filter on the status name to display the customer's information with new and invoiced orders only.

Now, let's have a closer look at our example. We have three tables in the FROM...