/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

savvinov.com
| | jonathanlewis.wordpress.com
2.0 parsecs away

Travel
| | [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...
| | iusoltsev.wordpress.com
1.8 parsecs away

Travel
| | 465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...
| | tonyhasler.wordpress.com
3.1 parsecs away

Travel
| | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...
| | roape.net
19.8 parsecs away

Travel
| [AI summary] The content is a cookie consent notice and introductory information about the Review of African Political Economy (ROAPE) journal, including subscription details.