Similiar SQL statement, performance improve?

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