Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		www.xt-r.com XT&R blackboard: ? distinct values ?, ? TopN
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	1.1 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	1.1 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Bind Peeking \| Oracle Scratchpad	2.3 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...	2.3 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: Searching over structured and unstructured data in 10G	1.9 parsecs away Travel
\|	\|	In my previous blog post I've explained a nice little feature introduced to Oracle Text Context indexes in 11G which allows you to do effic...	1.9 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com Expanding SQL \| Oracle Scratchpad	16.1 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	16.1 parsecs away Travel