The Oracle performance pack has a tuning expert and it is reasonably
inexpensive. It makes its recommendations based upon usage during the
collections period. So it is important that people use the system during
the collections period or you will get skewed answers. (GIGO)
Jim
"Walt" <wmaguire_at_extensity.com> wrote in message
news:3A032F58.846ED085_at_pacbell.net...
> Hello-
> I've recently inherited a very large and complex data model, and I
> need to begin evaluating the appropriateness of indexes. My main
> challenge is one of volume; this model has around 270 tables, and just
> under 700 indexes. It's the back-end for a software package which is
> designed to be customized on install, and could serve anywhere from a
> few dozen to tens of thousands of users.
> I'm hoping to avoid tuning based on complaints of poor performance.
> Does anyone have any suggestions or thoughts on evaluating this large
> a number of indexes?
> Thanks in advance.
>
> Walt Maguire
>
Received on Fri Nov 03 2000 - 21:29:11 CST
