|
|
Archives of the TeradataForum
Message Posted: Thu, 19 Oct 2006 @ 12:58:52 GMT
Subj: | | Collecting statistics on Join Indexes |
|
From: | | Raghavan, Gopal |
Hi everyone -
When I run an explain plan with diagnostics on, it recommends that I collect statistics on certain column combinations for Join indexes. I
know I can collect statistics on the join index as a whole with the index option, is there a way to collect statistics on column combinations? We
are on V2R5.
Any help is appreciated.
Best Regards,
Gopal Raghavan
| |