Why Oracle Indexes Sometimes Get Suppressed
A modification of the column side of a WHERE clause in Oracle can result in index suppresseion. Learn a few alternatives for writing the query that do not modify the indexed column.
Read MoreMost Popular Oracle
Understand the Oracle Index Merge
In Oracle 11g you can merge two separate indexes and use the result of the indexes instead of going to the table from one of the indexes, which can speed performance. Learn more.
Read MoreHow to Use the New Oracle 11g Result Cache
If you are executing the same queries over and over, using the RESULT_CACHE hint in Oracle 11g can make subsequent queries run faster. Learn more.
Read MoreCaching a Table in Memory for Oracle
Caching a small, often-used table into Oracle memory ensures that the data isnt pushed out of memory by other data, but can have unexpected results. Learn more.
Read MoreMaking the Oracle Query “Magically” Faster
When a query is run multiple times in succession, it becomes faster because the data is cached in memory. This can make the query seem faster when it’s not. Learn why.
Read MoreWhat If I Create a Bad Oracle Index?
While Oracle’s cost-based optimizer generally suppresses poor indexes, problems can still develop when a bad index is used at the same time as a good index. Learn why.
Read MoreWhen Should I Use an Oracle Index?
Choosing to use an index in Oracle depends on how the data and indexes are architected, how the data is distributed within the blocks, and how it is accessed.
Read MoreHow is AUTOTRACE Different from EXPLAIN PLAN?
The Oracle command AUTOTRACE executes the query (in the way TRACE does) and automatically queries the plan table, and the EXPLAIN PLAN command does neither. Learn more.
Read MoreUsing the Oracle EXPLAIN PLAN Alone
The EXPLAIN PLAN command allows you to view the query execution plan and can be helpful in improving the performance of SQL statements. Learn more.
Read MoreTop 25 Oracle Initialization Parameters
See one expert’s list of the 25 most important Oracle initialization parameters, in order of importance.
Read MoreUnderstanding the Oracle Optimizer Modes
The Oracle cost-based optimizer has two modes of operation: normal mode and tuning mode. Learn when to use these modes.
Read MoreOracle Pools Used to Store the Actual Data in Memory
The initialization parameters DB_CACHE_SIZE, DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE are the determining factors for memory used to store data in Oracle.
Read More