Help with Tuning

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 - 15:34:22 CST