Re: Help with Tuning

From: Steve Long <steven.long_at_erols.com>
Date: Fri, 3 Nov 2000 21:58:41 -0500
Message-ID: <8tvtqm$gq$1@bob.news.rcn.net>

find a good tool

"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 - 20:58:41 CST