Outer Web | Explore

Explore >> Select a destination

You are here		rwijk.blogspot.com About Oracle: Filter predicates with NVL on mandatory columns using the index
\|	\|	oracletoday.blogspot.com Oracle Today: Performance of Autotrace	1.1 parsecs away Travel
\|	\|	I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...	1.1 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	1.4 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...	1.4 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: Update and rownum oddity	1.1 parsecs away Travel
\|	\|	Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod...	1.1 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	8.7 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...	8.7 parsecs away Travel