://www.jlcomp.demon.co.uk/faq/ind_faq.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 18 February 2003 22:30
Anyone know anything about a /*+ CARDINALITY */ hint? I noticed it
while
extracting some MView fast refresh SQL. I can't seem to find anything
documented about
of list ORACLE-L [EMAIL PROTECTED]
Date: 18 February 2003 22:30
Anyone know anything about a /*+ CARDINALITY */ hint? I noticed it
while
extracting some MView fast refresh SQL. I can't seem to find anything
documented about it. any one have any info they want to share?
Robert
--
Please see
The last time I checked, there were about 60 hints
documented, and about another 60 things in the
executable that looked like hints.
The cardinality hint SEEMS to dictate a value
for the computed cardinality of a single table
access (see the 10053 trace) at any point where
Oracle says - when I
Anyone know anything about a /*+ CARDINALITY */ hint? I noticed it while
extracting some MView fast refresh SQL. I can't seem to find anything
documented about it. any one have any info they want to share?
Robert
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author