Collect Stats on Primary Indexes

Database
Kks
Enthusiast

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
Enthusiast

Re: Collect Stats on Primary Indexes

request replies
Enthusiast

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);

Senior Apprentice

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