Re: Which is faster?

Oracle supplies a couple of utilities called 'explain plan' and 'tkprof'. These will explain the execution path for any sql statement, allowing you to tune the statements by adding or removing indexes, or tweaking the statement itself. A scripts to set up the 'plan' table should be found in $ORACLE_HOME/rdbms/admin. The Oracle Server Peformance Tuning Guide should show you how to use the tools.

Without using these, there is no way to tell which is the best way to code a statement.

wychan wrote:

> Which of the following select statement is running faster:
>
> select * from table_a, table_b
> where table_a.column_1 = table_b.column_1
> and table_a.column_2 > 10;
>
> select * from table_a, table_b
> where table_a.column_2 > 10
> and table_a.column_1 = table_b.column_1
>
> Or they are homogenous?
>
> Thanks for any advice,
> River
> novice DBA
Received on Tue Dec 29 1998 - 20:10:26 CET