Outer Web | Explore

Explore >> Select a destination

You are here		jonathanlewis.wordpress.com Push Group by \| Oracle Scratchpad
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	8.9 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...	8.9 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	7.2 parsecs away Travel
\|	\|	When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE\|LIST\|HASH] ITERATOR or PX PARTITION [RANGE\|LIST\|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...	7.2 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	6.7 parsecs away Travel
\|	\|	The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...	6.7 parsecs away Travel
\|	\|	blog.jooq.org What's faster, COUNT() or COUNT() with LIMIT in SQL? Let's check	53.2 parsecs away Travel
\|		We check execution plans and benchmark results to see if using a LIMIT clause is useful when checking for existence of N values in SQL	53.2 parsecs away Travel