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
\|	\|	www.xt-r.com XT&R blackboard: ???????????? ??????????? ????????? distinct values ?? ???????, ? ????? TopN ??? ???????	1.1 parsecs away Travel
\|	\|	????????? ???? ????? ?? ?????? ??????, ??? ?????????? ??????????, ??????, ???????, ????? ? ??????? ??????????? ?????? : ???? ????? ????????...	1.1 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Using "nonunique index to enforce uniqueness" is a good way?	0.8 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.	0.8 parsecs away Travel
\|	\|	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
\|	\|	jonathanlewis.wordpress.com Index Hints \| Oracle Scratchpad	19.5 parsecs away Travel
\|		I've lost count of the number of times I've reminded people that hinting (correctly) is hard. Even the humble /+ index() / hint and its close relatives are open to misunderstanding and accidental misuse, leading to complaints that "Oracle is ignoring my hint". Strange though it may seem, I'm still not 100% certain of what...	19.5 parsecs away Travel