Advised Indexes since 7.3 upgrade

There's been a marked change in the number of EVI indexes advised since 7.3 was installed. I cleared the advised indexes for one library before the nightly batch run. Afterwards were the expected Times Advised quantities of up to around 60 except for two EVIs which were advised 79K times! Some of the advised EVI indexes have high expensive query estimates.

Also the advised indexes are not what are classically (what Dan Cruikshank taught us in SQL Tuning and Monitoring Workshop) used for EVIs. These are account numbers (Approx 185K), dates, and other high key cardinality fields.

Has anyone else had similar results since 7.3?

Has the general rule changed for best practices use of EVIs and Radix indexes?

One of the files in question is around 25 million rows so I don't want to waste a lot time building indexes that aren't that useful.

Thanks in advance.

Jack Prucha
Programming Team Supervisor

College Foundation, Inc.
Office Phone: 919.835.2530

This email, including any documents, files, or previous email messages attached to it, has been sent from an email account of College Foundation Inc., (CFI) and may contain confidential, proprietary, or legally privileged information belonging to CFI. If you are not the intended recipient, any dissemination, distribution, or copying of this email or its attachments is strictly prohibited. If you have received this email in error, please immediately notify the sender by email and destroy the original email and any attachments.