 |
 |
Archives of the TeradataForum
Message Posted: Tue, 16 Dec 2003 @ 21:57:55 GMT
| Subj: | | Re: Collect Stats on Single Column SI |
| |
| From: | | Victor Sokovin |
Fred,
| | Permitting additional keywords in the syntax of the COLLECT STATS statement does NOT cause the method of collection or the resulting
stats to be any different from the other syntax form. | |
The syntax diagram offers a large number of combinations because most building blocks are optional: USING SAMPLE (yes/no), index name
(yes/no), number of columns in column_name_1 and column_name_2 and the options I mentioned before. If all these combinations lead to the
same statistics then what was the ispiration behind this command?
| | Note the "Advantages of the CREATE INDEX syntax" section a few pages later in the manual... | |
Found the paragraph. Do you read it like the only real advantage is that you can collect stats on a few indexes in one statement? If so,
why?
Victor
| |
