GATHER_PLAN_STATISTICS hint
"MCALLISTER, MICHAEL CTR AU Contractor AETC AETC/A3IS" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <4DA48F51EE503444872CA8706603DE501DA77FDF59@52VEJX-MV14-01.area52.afnoapps.usaf.mil> |
I just came across a tuning / investigative method using the GATHER_PLAN_STATISTICS hint as described here:- https://blogs.oracle.com/optimizer/entry/how_do_i_know_if Usually when I come across this, I find out that TOAD has this already baked in. Is this the case here? Is there some automated method in TOAD to have it run a query, add the hint, and get the estimated vs actual rows plan info back for me? Regards, Mike McAllister Principal Systems Engineer Decypher DSN: 487-3751 Commercial: (210) 652-3751 Cell: (512) 423-7447 Email: [email protected]
smime.p7s
(application/x-pkcs7-signature, 5.5 KB) - not displayed