I’m using Quest SQL optimizer 7.4.1 and oracle 10.2.
I would to optimize a query and generate virtual indexes.
I copy the SQL query and click on the generate virtual indexes button. and an Information dialog box opens (see the attached image) and tells me that
“The Index Expert did not find any index or set with a unique execution plan using the Intellignece Level setting to 5…”
I tried the different settings whit allways the same information dialog box.
How can I take benefit of Generate Virtual indexes?