Collect Stats on Primary Indexes

Database
Kks
N/A

Collect Stats on Primary Indexes

Hi,

Is ther any different syntax to collect stats on Primary indexes or just collecting the stats on column will do the some

Thanks
3 REPLIES
Kks
N/A

Re: Collect Stats on Primary Indexes

request replies

Re: Collect Stats on Primary Indexes

yeah as far i know thats the only way to collect stats...

eg:
COLLECT STATISTICS ON employee
INDEX(EmpNo, Name);

N/A

Re: Collect Stats on Primary Indexes

If the stats are collected on all PI columns as multicolumn stats there's no difference between index or column stats. It's just easier to write "Collect stats on tablename index indexname" than "Collect stats on tablename column(columnname1, columnname2, columnname3)".

Dieter