Re: Gathering statistics for a specific schema
- From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
- To: crcbedoy@xxxxxxxxxxxxxxxxx
- Date: Tue, 3 Oct 2006 09:42:11 -0500
There are many things you can do with stats, and some of them are downright
really cool. But taking a step back from the syntax, let me ask, why or how
do you know you "need" the stats for a specific schema? Have you identified
a query and/or a column that is/are performing poorly because of missing or
inaccurate stats (or even accurate stats for that matter)? Once you answer
these questions, you can then proceed to answer other questions like "What
kind of stats do you need, in particular?"
On 10/3/06, crcbedoy@xxxxxxxxxxxxxxxxx <crcbedoy@xxxxxxxxxxxxxxxxx> wrote:
Hi,
I need your help, I am new to the usage of statistics and I need to get
the statistics for a specific schema. I know that by using the package
DBMS_STATS.GATHER_SCHEMA_STATS I can the statistics, but I don't know how to
manipulate them. Could you guys give me a clue about what should I do or
where can I find information about using this packege and manipulating
information given by it?
Thanks a lot for your help:)
Isabel Bedoya Gómez
Gestión de Tecnología
Tel. 2307500 ext: 4077
--
Charles Schultz
Other related posts:
