tag:blogger.com,1999:blog-723572961554940315.post6664707000616005433..comments2023-10-08T19:26:21.745+05:30Comments on Ask Anantha: SQL Tuning Guidelines for Oracle - Simple yet Effective!Anantha Narayananhttp://www.blogger.com/profile/01235733287809115092noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-723572961554940315.post-767628845638498442012-09-06T17:16:49.614+05:302012-09-06T17:16:49.614+05:30Can you please guide me on how to tune below query...Can you please guide me on how to tune below query<br /><br /><br />DELETE /*+ NOLOGGING PARALLEL(48) */ from emp A<br />where A.salary < any (select /*+ PARALLEL(48) */ MAX(salary)<br /> from emp B where A.deptno = B.deptno); <br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-723572961554940315.post-8998132681082404882012-06-11T13:52:28.683+05:302012-06-11T13:52:28.683+05:30Excellent post...looking for some more on the quer...Excellent post...looking for some more on the query tuningAnonymousnoreply@blogger.com