Re: SQL query Tuning
From: Erik <erik_at_evd.be>
Date: 6 Nov 2001 04:42:21 -0800
Message-ID: <aeb3790f.0111060442.3702b008_at_posting.google.com>
Date: 6 Nov 2001 04:42:21 -0800
Message-ID: <aeb3790f.0111060442.3702b008_at_posting.google.com>
rewrite your statement with
but you have to know how many rows you need about this table when you
want to exclude this product_range .....
why do you use rule hints ?
why not all_rows ?
did you already tried select /*+ parallell(ipar1 , 15) */ when you
have multiple cpu's ont this machine ...
Kind regards
select X
where
WHERE IPAR1.product_range_id > IPAR2.product_range_id
union
WHERE IPAR1.product_range_id < IPAR2.product_range_id