HowTo find out used (useful) and unused (usesless) indexes?

From: Andreas Mosmann <mosmann_at_expires-30-04-2008.news-group.org>
Date: Thu, 17 Apr 2008 11:38:22 +0200
Message-ID: <1208425102.29@user.newsoffice.de>

Hi,

Is there a way to find out what indexes are used(useful)/unused(useless) while the last few days/weeks?
If possible so tell me a way via data dictionary without using any external tools.

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de

Received on Thu Apr 17 2008 - 04:38:22 CDT

This message: [ Message body ]
Next message: Vabs: "Oracle Trigger Late binding"
Previous message: Urs Metzger: "Re: Hierarchical Subquery must omit nodes"
Next in thread: fitzjarrell_at_cox.net: "Re: HowTo find out used (useful) and unused (usesless) indexes?"
Reply: fitzjarrell_at_cox.net: "Re: HowTo find out used (useful) and unused (usesless) indexes?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message