Improve Oracle Performance by Reducing Calls to SYSDATE
Calls to the Oracle variable SYSDATE, though convenient, involve some overhead, and should be reduced where possible. Learn more.
Read MoreMost Popular Databases
Use ROWID for Iterative Processing in Oracle
The Oracle ROWID is the fastest access path to a record in a table, even faster than a unique index reference. Learn how this can improve performance.
Read MoreReduce PL/SQL Program Unit Iterations in Oracle
Any Oracle PL/SQL program unit involving looping logic is a strong candidate for performance improvements, and there are several ways to accomplish this. Learn more.
Read MoreIncrease Oracle 11g Performance with Native Compilation
Because natively compiled code in Oracle doesn’t need to be interpreted at runtime, it may execute faster. However, performance gains depend on several factors. Learn more.
Read MoreUse Named Parameters in SQL Function Calls in Oracle 11g
Named notationis the preferred method for passing parameters to subroutines in Oracle. With 11g, you can extend this to SQL statements to yield consistency across the entire code base.
Read MoreReference Sequences Directly in PS/SQL Expressions in Oracle 11g
With Oracle 11g, you can reference sequences directly in PL/SQL expressions, resulting in more streamlined code and improved performance. Learn more.
Read MoreSnapshot Too Old Error In Oracle: Developer Coding Issue
Oracle holds undo information in case you need to roll back a transaction and also to keep a read-consistent version of data. Learn why this can sometimes cause Snapshot Too Old errors.
Read MoreTuning Distributed Queries in Oracle
When distributed queries can’t be avoided, use IN clauses, set operators such as UNION and MINUS, and use everything else you can to reduce the network traffic between database nodes. Learn more.
Read MoreBest Uses for the Oracle Bitmap Join Index
This article exanmies three excellent uses for bitmap join indexes in Oracle: on columns other than the join; on multiple columns; and on multiple tables.
Read MoreUnderstanding Three-table Joins in Oracle
In a three-table join, Oracle joins two of the tables and joins the result with the third table. Learn how Oracle determines which is the driving table in a query.
Read MoreUnderstanding Oracle INDEX-MERGE Joins
Unlike Oracle fast full scans that have a single index satisfying the entire query, INDEX-MERGE joins have multiple indexes satisfying the entire query. Learn how this impacts performance.
Read MoreUnderstanding Oracle HASH Joins
HASH joins in Oracle can be effective when the lack of a useful index renders NESTED LOOPS joins inefficient. Learn more.
Read More