The Index Advising Details window is optional and can be displayed after index candidates are generated. This window displays the number of index candidates generated.
The Index Advising Details window is shown every time the index generation is finished unless it is disabled. You can disable it by clearing the Show details on next index advising option in the Index Advising Details window.
To open the Index Advising Details window
Select View | Show Index Advise Details.
If no alternative index candidates are generated, is available for you to directly copy the original SQL statement from the Index Advisor to the SQL Optimizer for optimization. The optimization process will start automatically. It applies advanced SQL transformation technology to generate a list of semantically equivalent SQL statements that you can test in your environment to find the best performing SQL statement.