To execute an SQL statement, there are usually several search strategies available to the database system. These strategies differ in the costs that they incur when they are executed.
SQL Optimizer,
Database Studio, Displaying the Search Strategies Used by SQL Statements (EXPLAIN)
Database Administration in CCMS, Command Monitor