I have 2 questions on the collect statistics statement:
1. Can the collect statistics option be run on the Primary Index and the Secondary Index (PI and SI) at the SAME time..?
2. How do i view the results of the Collect Statistics table.
I'm using Teradata.
Thanks.