Outer Web | Explore

Explore >> Select a destination

You are here		oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
\|	\|	jonathanlewis.wordpress.com Bind Peeking \| Oracle Scratchpad	1.2 parsecs away Travel
\|	\|	Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with...	1.2 parsecs away Travel
\|	\|	rwijk.blogspot.com About Oracle: dbms_xplan.display_cursor	1.4 parsecs away Travel
\|	\|		1.4 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	1.6 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.6 parsecs away Travel
\|	\|	www.xt-r.com XT&R blackboard: ?????? ????????????? "member of" ? ??????????? ? ?????????? ?????????	28.4 parsecs away Travel
\|		????? ????? ???????? ? ??????? ????????????? "a member of b" ????? ???????? ??????? ?????????? ????? a in (select column_value from table(...	28.4 parsecs away Travel