Information design tool 4.0: Apply a WHERE clause restriction to a foreign key index
Index awareness is the ability to take advantage of the indexes on key columns. When you set up index awareness in a universe, you indicate in the information design tool which database columns are primary and foreign keys to speed up data retrieval. In addition, you can set up a WHERE clause restriction that will use the applied primary or foreign key index.
In this tutorial, you will apply a WHERE clause restriction to a foreign key index.