Ref:(Shared Pool).

Hi,

I believe sql-statements which follows indexes will be kept in shared pool for further usage, because they will have explain plan, parsed code and all.

My question is will sql-statements which do full table scaning be stored in shared pool?.

Exactly what kind of sql-statements will be stored in shared pool?.


Please do give me proper explanation about this?.


Cheers,

go to tahiti.oracle.com and read concepts guide, clear and very good explanation