Knowing the type of database application helps the Index Tuning Wizard determine the type and number of indexes to recommend. |
| Select Online Transaction Processing (OLTP) if the database is used primarily for transaction processing. |
| Select Data Warehousing if the database is used primarily for creating customized data queries and reports. |
| Select Multipurpose if the database is used for a variety of application types. |