Explore >> Select a destination

You are here

 www.xt-r.com
XT&R blackboard: ???????????? ??????????? ????????? distinct values ?? ???????, ? ????? TopN ??? ???????
| | 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...
| | antognini.ch
V$SQL_CS_HISTOGRAMS: What Are the Buckets' Thresholds? - Striving for Optimal Performance
2.5 parsecs away

Travel
| |
| | 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.
| | tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines????? | Tony's Oracle Tips
16.9 parsecs away

Travel
| Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...