-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|