Re: Similiar SQL statement, performance improve?

Nope, it has to be exactly the same statement, or it is parsed again. If the statements below used bind variables and the value was passed in, then they would be exactly the same and would be parsed once and executed twice.

Thanks,
Dave

Jimmy wrote in message <350A0538.3E6_at_comp.polyu.edu.hk>...
>Hello all,
>
> I know that a SQL statement is stored in the shared pool of the SGA
>once a statement is executed. The purpose is to improve the performace
>when the same SQL statement execute again.
>
> If SQL statement1 is : "select * from table1 where table1.att =
>'TEMP1'"
> and sumbitted to Oracle to execute.
>
> Then another SQL statement2 : "select * from table1 where table1.att =
>'TEMP2'"
>
> I want to ask, is statement2 gain the improvement after statement1 is
>executed?
>
>Thanks,
>Jimmy
Received on Fri Mar 13 1998 - 00:00:00 CST