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:
NorthWindBusiness layer and then navigate to the Business Layer tab from the left panel.
Status Namedimension under the