Home -> Usenet -> comp.databases.oracle -> Re: SQL query Tuning

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> 







rewrite your statement with 


select X


where


WHERE IPAR1.product_range_id            > IPAR2.product_range_id
union


WHERE IPAR1.product_range_id            < IPAR2.product_range_id



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
Received on Tue Nov 06 2001 - 13:42:21 CET












Original text of this message