Toad World® Forums

does SGA inspector have way to get sql that contains specific table


this would make it easier to get all sql using a specific table so you could then feed just that sql to “Impact Analser” when adding an index to that table.
i am finding I get over 10,000 sql in “Sga Inspector” and I cannot reduce this to the
30 or 40 sql i need for “impact Analyser”.
I do not seem to be able to save all the sql to repository, it always aborts.



Thank you for providing this feedback. The product currently doesn’t have the feature to send SQL to Analyzer by criteria. I will create an enhancement request based on your suggestion. I think it will be a good enhancement to the product.

Thanks again for the feedback.