tag:blogger.com,1999:blog-13265058.post116313833643533925..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: FULL SCANs must be bad, SQL Developer Says so.SydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-13265058.post-1163495660714540952006-11-14T20:14:00.000+11:002006-11-14T20:14:00.000+11:00Well Query Optimization is a complex thing . Overa...Well Query Optimization is a complex thing . Overasll I have found SQLDeveloper quite good.Ptrikhahttps://www.blogger.com/profile/07632424753084090532noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-1163379175698255872006-11-13T11:52:00.000+11:002006-11-13T11:52:00.000+11:00Good on you, sql developer folks, for listening.Th...Good on you, sql developer folks, for listening.<BR/><BR/>That's a lot more than has been happening in other areas of Oracle.<BR/><BR/>Gotta give it another try, I reckon, just for that!Noonshttps://www.blogger.com/profile/07694829378563989648noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-1163195373373484932006-11-11T08:49:00.000+11:002006-11-11T08:49:00.000+11:00I'm impressed with the support for SQL Developer. ...I'm impressed with the support for SQL Developer. That's a quick response. I think I may not have been so irked if the highlight was in blue rather than red. Blue is a more 'hey look at me' whereas red is 'hey, somethings wrong'.<BR/><BR/>Personally, I'm not convinced by the 'missing indexes' argument, but if you expand it to 'invalid indexes' I'd be inclined to agree.<BR/><BR/>As for cartesian joins, even an SQL as simple as <BR/>SELECT ord.order_date, item.qty <BR/>FROM orders ord, order_item item<BR/>WHERE ord.order_no =:ord_no<BR/>AND item.order_no =:ord_no<BR/>AND item.item_no=:ord_item_no<BR/>may use a cartesian join. Most of the times I see a cartesian join, it is between single row sets.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-1163145700505821902006-11-10T19:01:00.000+11:002006-11-10T19:01:00.000+11:00Of course, full table scans on inapropriate tables...Of course, full table scans on inapropriate tables are a very very common symptom of missing indexes... <BR/><BR/>I've always found the highlighting in SQL Navigator to be quite useful since it reminds me the check that the full table scan is appropriate. And in 8 years of Oracle I can only remember a handful of times when a cartesian join was actually required.<BR/><BR/>As with everything else out there, you need to understand what it's saying before you act. That doesn't mean the highlighter isn't useful!Rob Bailliehttps://www.blogger.com/profile/06513796097645814224noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-1163141482326379132006-11-10T17:51:00.000+11:002006-11-10T17:51:00.000+11:00Just a note to say that Quest SQL Navigator does c...Just a note to say that Quest SQL Navigator does color the "TABLE ACCESS FULL" in red as well, even if you select * from dual.Eddie Awadhttps://www.blogger.com/profile/12834637955019429063noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-1163140220178353992006-11-10T17:30:00.000+11:002006-11-10T17:30:00.000+11:00I just removed the colors in the source and the ne...I just removed the colors in the source and the next update of the tool will have that. The idea is that the user can define colors for the different operations however the prefernece pane for that has not been made yet.Anonymousnoreply@blogger.com