Oracle - sqltuning and statistics
Date: Fri, 27 Apr 2001 08:53:38 GMT
Message-ID: <msaG6.4109$Sq.397967_at_juliett.dax.net>
Hi all,
In a schoolproject I have been asked to say something about statistics in a
sql tuning setting for Oracle. But I am confused about the word statistics
(English is not my first language either). It seems that there is two kind
of statistics, one concering the objects (tables, indexes etc), which is
really accumulated and fresh information about the objects themselves ("If
the size and data distribution of these tables changes frequently, generate
these statistics regularly to ensure the statistics accurately represent the
data in the tables"). And the second kind is more what one would think
statistics to be in sql tuning , cpu-time, number of times a statement has
been parsed, executed and fetched, total numbers of datablocks read, etc.
Is this duality right? Have I (mis-)understood? Could anyone comment on this
please?
Ann Received on Fri Apr 27 2001 - 10:53:38 CEST