Select to include information about the creation of indexes by monitored jobs. Temporary indexes may need to be created for several reasons such as to perform a join, to support scrollable cursors, to implement ORDERBY or GROUP BY, etc. The created indexes may only contain keys for rows that satisfy the query (such indexes are known as sparse indexes). In many cases, the index create may be perfectly normal and the most efficient way to perform the query. However, if the number of rows is large, or if the same index is repeatedly created, you may be able to create a permanent index to improve performance of this query. This may be true whether or not an index was advised.