In both the tables should be data but for the test there are none. With
full of data tables it gives me similar results.
The output of tkprof gave me these results:
Case 1 (create definition):
select tab2.col1, count(tab1.col1) pocet
from tab2, tab1
where (tab1.tab2id=tab2.id) and (tab1.col2
I would strongly recommend a good beginner DBA text
such as DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1044859784
This will give you a good foundation for reading the docs.
Jared
On Saturday 08 February 2003 18:28, majid wrote:
> Hi,
> I used to use mysql databse, no
Hi,
This is test msg. pl. ignore.
srinivas
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: kommareddy sreenivasa
INET: [
I have just begun trying Column histograms and have
seen a better execution plan for a query
on LOTRUN.RECTYPE when
a) LOTRUN had about 5million records
b) RECTYPE='A' is only 1570 records
c) RECTYPE='H' is the other 5mn-1570 records
We wanted the RECTYPE Index to be used because all
of our
A unique index only says that all of the values therein are unique. There is no
need to insert the values in a particular order. That being the case the index
can become unbalanced requiring a rebuild.
Dick Goulet
Murali Menon <[EMAIL PROTECTED]> wrote on 2/9/03 12:43 pm:
Uniqueness indicates t
For DSS systems (especially where there a lots of ad-hoc queries), be liberal with
histograms. They can have a significant positive impact on the join-order chosen by
the CBO even when the columns don't look skewed.
There is additional cost in CPU, cache and system tablespace(especially if you d
Uniqueness indicates that there are less skewed values correct! Under what circumstances would a skewed column value for a unique column exist.
Another question, what about histograms on indexes itself? If histograms are generated on columns with skewed values, does it matter when the indexes are
vmstat –PP for RAM size.
psrinfo For
processor related info.
swapon –s To check swap info.
To determine which operating system subsets
are installed, enter the following command:
$
setld -i | grep installed
To determine which operating system version
is i