chapter about indexes, statistics and the Curses Based Optimizer, am I right)
is not distributed evenly, with small variations in the number of rows for any given key, but that there is a small subset of keys which corresponds to significant part of the table. Speaking mathematically, there exists at least one value in the indexed columns so that the number of rows corresponding to this value is significantly larger then the average number of rows per value.
In other words, it means that the application relying on such index is
skewed up. On 2003.07.25 01:39, orababy wrote:
List,
Came across "~data is skewed~" while reading the docs.
what does it actually mean ?
can someone explain this for a novice dba like me.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
