Re: Designing indexes

From: HansF <News.Hans_at_telus.net>
Date: Thu, 09 Feb 2006 17:29:22 GMT
Message-Id: <pan.2006.02.09.17.29.21.750376@telus.net>

On Thu, 09 Feb 2006 07:25:38 -0800, News wrote:

> Anyone know about tool that helps designing indexes ? the tool must
> consider user queries and stats on tables.

The only two tools I have seen that help here are experience and understanding of the application/environment (eg: intelligence).

Although - from Oracle - the Enterprise Manager Diagnostic Pack, specifically AWR and ADDM in 10g, is an attempt to assist with this requirement.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Thu Feb 09 2006 - 11:29:22 CST