Hi experts,
Regarding index optimization in SQL Optimizer for Oracle, there are two features: Optimize SQL and Optimize Indexes.
What is the difference between these two?
Also, I noticed mentions of physical indexes and virtual indexes.
How do they work within this product?
My version is 10.2.0.2460.
I was going to repost your question in the SQL Optimizer forum, but I see we don't have one. That's really a question for that team, not Toad for Oracle. You are probably best off opening support cases for SQL Optimizer cases rather that posting in the forum.
That said - I think the answer is that SQL Opt will actually create these indexes to try out your SQL and see if it is faster that way.
Hi John~
Thank you for your kind help. 
I will open the support ticket to follow up on this.
As we are planning to promote this, I’d like to gain a better understanding of these details.
