Oracle - sqltuning and statistics

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 - 03:53:38 CDT