Explore >> Select a destination
|
You are here 
|
blog.sqlora.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note that Lukas Eder wrote in 2016 with the title: "Avoid using COUNT() in SQL when you could use EXISTS()". This is a good guideline because it probably maximises the options the optimizer has for producing a good execution plan, but it's not... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Here's a little thing that Dan Morgan mentioned to me some time ago. It's a little routine from a package (owned by sys) that appeared in 11.2.0.3 that gives you some idea of the mess hidden behind a query that uses views. The procedure is called dbms_sql2.expand_sql_text and it takes two (CLOB) parameters: an IN | |
| | | | |
sqlmaria.com
|
|
| | | | | Database views have been used for decades to help simplify both ad-hoc queries and reporting for developers, analysts, and end-users. But the problem with defining views is they tend to be either t... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | [More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you... | ||
