Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Wrong Results using function in group by (8.1.6)

Re: Wrong Results using function in group by (8.1.6)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/06/29
Message-ID: <962317129.8857.7.nnrp-10.9e984b29@news.demon.co.uk>#1/1 







A nine table join is a bit nasty.


This shouldn't make any difference, but


can you hint it to take a different access 
path and see if that makes a difference.



It is possible that if you have HASH 


joins in here, or bitmap driven access,


or some parallel execution than data


gets 'lost'.



What is the access path (as produced


by EXPLAIN PLAN).



-- 




Jonathan Lewis


Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk




--

Received on Thu Jun 29 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US