/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

 rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
| | iusoltsev.wordpress.com
FIRST_ROWS CURSOR_SHARING_EXACT | Oracle mechanics
1.3 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...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
1.2 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
1.4 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | carlos-sierra.net
SQLTXPLAIN 101 | Carlos Sierra's Tools and Tips
12.9 parsecs away

Travel
| SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1. Q: What do you get from this tool? A: In...