How to get recommendations of virtual indexes for SQL?
说明
I have been trying to migrate from Quest Central for DB2 to Toad for DB2 and I cant find the recommend virtual indexes option in the explain tool. Where is this option in Toad for DB2?
解决办法
In order to get recommendations for indexes that could be created to optimize your code, you would need to have SQL Optimizer for DB2. There is an Index Expert in SQL Optimizer for DB2 that you can run that will list the indexes that can created on the code and then it will tell you how helpful creating the index would be. There is not a feature like this in Toad for DB2.
