Cherie:
>My question is this: In general, this data appears to
>be fairly well-distributed. However, does the fact that
>for each Saturday and Sunday there are zero rows
>mean that this data is skewed? Might this column be
It depends. My gut would say no. But the real test would be a
statistical one. You must look at the distribution of the data
in the column and compare it against a theoretical normal distribution.
My criterion is that if the data distribution is different from
the theoretical norm by more than 2 standard deviations, I consider
it skewed and consider it a candidate for a histogram. Again,
a good candidate is also one that is used in a where clause of
a commonly-used query as a literal predicate.
Hope this helps.
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
