-
query tuning
Last edited by hannah00; 03-16-2005 at 11:11 AM.
-
-
-
any imput would be greatly appreciated
-
Merge join may slow down execution. Try HASH join.
Also you have to treat date datatype as date.
See below:
'01-NOV-2004' BETWEEN AGH.EFF_DT_FROM AND AGH.EFF_DT_TO
Tamil
-
thanks Tamil,
the problem is sorting, it kept ran out the temp tablespace even it already had 6G.
-
A merge join will probably use more memory\temp tablespace for sorting than a hash join. Try Tamil's suggestion. Assuming you are using CBO (rahter than RBO) it should be the most efficient approach.
Assistance is Futile...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|