Hi,
I am very new to Toad and I have a very basic question. I have installed Quest SQL optimizer 8.7.1 for Oracle. If I use this for checking better versions of a given query for improved performance, does it only provide me with options or does it actually make any kind of changes to the objects associated with the query or current execution plan or statistics.For example if I were to check for elapsed time with a new index on a relatively huge table, would it actually create the index for this? Please clarify. I only want to know if I can safely use this software just for the sake of comparison without actually making any changes without the approval of my next level of experts. Thanks a lot in advance.