When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored ?
The access path information for the PACKAGE is stored as skeleton package tables in the SPT01 table.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How can I transfer the particular DTS package from one SQL Server to another ? 23.07.08
There are two ways to move DTS package: 1. Save DTS package as file on the disk, then copy this file on the target SQL Server and load this DTS package on th...How do I run a DTS package from the Query Analyzer or stored procedure ? 21.07.08
There are two ways to run a DTS package from the Query Analyzer or stored procedure: 1. By using OLE Automation objects (run sp_OACreate, sp_OAGetProperty,...What is a TEXT_IO package? 19.05.08
The Text_IO package allows you to read and write information to a file in the file system....DB2 What is the difference between a package and a plan? How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem? 03.04.08
Package and plan are usually used synonymously, as in this site. Both contain optimized code for SQL statements - a package for a single program, module or subr...What are the advantages of using a PACKAGE ? 16.03.08
The advantages of using PACKAGE are: 1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid cost of a large bind 3. Avoid the entire tra...What are Packages ? 27.06.06
A PACKAGE is a PL/SQL object that groups PL/SQLÂ types, variables, SQL cursors, exceptions,procedures, and functions.Each package has a specification and a bod...What is a package ? 16.03.06
A PACKAGE is a PL/SQL object that groups PL/SQLÂ types, variables, SQL cursors, exceptions,procedures, and functions.Each package has a specification and a bod...Q.What are packages and why ? how to execute a program in a package ? 08.03.06
Package is a set of classes, which can be accessed by themselves and cannot be accessed outside the package. and can be defined as package .Package name and th...What r packages and why ? how to execute a program in a package ? 08.03.06
Package is a set of classes, which can be accessed by themselves and cannot be accessed outside the package. and can be defined as package .Package name and th...What are packages and why ? how to execute a program in a package ? 07.03.06
Package is a set of classes, which can be accessed by themselves and cannot be accessed outside the package. and can be defined as package .Package name and...