What is Skeleton cursor table (SKCT)?

Answers were Sorted based on User's Feedback



What is Skeleton cursor table (SKCT)?..

Answer / s

Skeleton cursor table contains the bound plan.

Is This Answer Correct ?    4 Yes 1 No

What is Skeleton cursor table (SKCT)?..

Answer / vat

Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

Is Cursor exicutable ?

3 Answers   TetraSoft,


What is a bind in db2?

0 Answers  


What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,


Give the name of some fields form sqlca.

0 Answers  


What is a Cartesian product?

2 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


How is deadlock resolved?

0 Answers  


What is the latest version of ibm db2?

0 Answers  


what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,


Categories