SQL Developer Tips

This topic discusses tips for SQL developers.

• SQL Optimization Guide
  This document discusses SQL optimization techniques.
• Avoid Transient Tables
  This guide gives advice for avoiding the use of transient tables.
• Prevent Database File Corruption
  
• SQL Index Tips
  This document includes several tips for using SQL indexes.
• SQL Insertion Tips
  This guide provides some tips for using COMMIT statements.
• SQL Schema Tips
  This guide gives tips for using the database schema.
• SQL Expressions
  This document explains how the optimizer changes expressions.
• SQL Statement Tips
  This guide provides tips for using certain SQL statements.
• SQL Joins
  This guide explains how to use CROSS JOIN phrases to override the optimizer's ordering of tables.
• ANALYZE Command
  This guide gives details of how to use the ANALYZE command to help the optimizer.
• SQL WHERE Clause Tips
  This guide provides tips for using the WHERE clause.