About Oracle Function-based Indexes
Function-based indexes in Oracle allow you to create an index based on a function or expression. Learn how this can impact performance.
Read MoreMost Popular
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 MoreUnderstand 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 More