/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
| | 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...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
1.2 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.
| | 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...
| | alexzeng.wordpress.com
# Expert Oracle Practices # PL/SQL and the CBO | Alex Zeng's Blog
13.8 parsecs away

Travel
| I am reading Expert Oracle Practices by Oracle Database Administration from the Oak Table. I'd like to summary and share what I learned. This chapter PL/SQL and the CBO by Jo?e Senega?nik is pretty interesting. It tells how to use oracle extensible optimizer to set the selectivity and the cost of PL/SQL functions. This will...