Archives of the TeradataForum
Message Posted: Thu, 27 Mar 2008 @ 22:02:38 GMT
| Subj: || || Re: COLLECT STATISTICS on Indexed Columns & |
| From: || || Christie, Jon |
Collecting stats does not GUARANTEE anything, but quite frequently it helps the optimizer find a more performant plan. To get a list of
statistics that might help the optimizer, use the HELPSTATS diagnostic:
diagnostic "helpstats" on for session;
The list of recommendations will appear at the end of the explain. There's also a STATISTICS WIZARD with its own manual.