Demo of a New Advanced Utility to Maximize Oracle SQL Execution Efficiency
Date: Tue, 4 Sep 2012 18:31:47 -0700 (PDT)
Message-ID: <8cbb75b1-4c7b-4330-b00a-cb4230eb16a0_at_googlegroups.com>
THE OPTIMUM SQL EXECUTION UTILITY
OPTIMIZE ORACLE SQL EXECUTION EFFICIENCY
This is an introduction to a new utility that maximizes Oracle SQL
execution efficiency and decrease’s execution run times. A SQL query
that is executing in minutes is reformulated using specially developed
Optimum SQL execution utility histograms, density factors and algorithms
and now executes in seconds.
The methodology and approach taken by this product to maximize Oracle
SQL efficiency is unique and revolutionary, no other product in the market
has taken this approach. It maximizes SQL efficiency at the back end not
the front end like most other products.It is a product that can be used
by any version of the oracle database that uses the cost based optimizer.
This product can increase the SQL efficiency of any application using the
Oracle database software.
The Optimum Histogram Utility, calculates optimum oracle table column
histograms for oracle databases. This utility is not a substitute for oracle’s
analyze or dbms_stats utilities that calculate histogram values as well as
other valuable statistics on a table.
It is an add on utility who’s purpose is to efficiently calculate the maximum
number of buckets, minimal bucket width and maximum number of popular values
for a column. The Optimum Histogram Utility produce histograms that increase
the efficiency and accuracy of the oracle optimizer in estimating SQL statement
result set sizes and using these estimates, select the optimal query execution
plan. This utility performs a type of super analyze on the column data
distribution and attributes using special algorithms and stores the
calculated results into a specialized OHU histogram. The OHU histogram now
contains optimum level detail on data distribution and statistics for a column.
This utility works against various oracle objects including heap and partitioned
tables (Hash, range and list) and materialized views and Index organized tables.
COMPARISON OHU AND ORACLE HISTOGRAMS
The following is a comparison of the characteristics and attributes of the OHU
histogram’s and the standard generated histogram.
1) No maximum bucket limit 2) Contains maximum number of popular values. 3) Contains smallest bucket widths feasible given data skew and table volume. 4) Maximum accuracy density and popular value estimates. 5) Non popular data value counts in the same bucket have the smallest feasibledeviation from each other given data skew and table volume. Thus estimated sizes of values within a bucket are closer to the bucket mean and allow the oracle optimizer to be more accurate at determining the estimated result sizes. 6) Popular value counts rounded to the nearest bucket to increase the accuracy of popular value estimated counts.
7) More popular values are calculated, thus lower density. Greater estimation accuracy on all operators for non-popular values. 8) Maximum bucket counts for popular values calculated providing greater estimation accuracy to the oracle optimizer.
The result is unequaled
oracle optimizer estimation accuracy and optimal execution plan selection
This utility has been passed Technical evaluations by outside vendors.
We at Optiwarehouze are excited about this break through product and the impact on performance it will have on your oracle databases.
We are now looking for DBA's willing to test this new utility. Free trial copies of this utility will be supplied to all interested DBA's or companies.
Please view our youtube presentation that explain the architecture
and revolutionary approach taken by this product with an actual demonstration
against an Oracle 11.2.0.1 Database.
http://www.youtube.com/watch?v=yPasotio22Q
Please contact us at the OptiWarehouze Corporation through linkedin or by e*mail optiwarehouze_at_gmail.com Received on Tue Sep 04 2012 - 20:31:47 CDT