Outer Web | Explore

Explore >> Select a destination

You are here		tanelpoder.com New scripts: xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 1) \| Tanel Poder Consulting
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins	11.3 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.	11.3 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	9.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...	9.8 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Expanding SQL \| Oracle Scratchpad	10.0 parsecs away Travel
\|	\|	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	10.0 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com dbms_xplan - again \| Oracle Scratchpad	66.2 parsecs away Travel
\|		I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a...	66.2 parsecs away Travel