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

What is meant by a unit of recovery?

1 Answers  


What is the difference between CS and RR isolation levels?

1 Answers  


How can you count the number of rows from a table tab?

0 Answers  


What is host variable?

0 Answers  


Compare a subselect to a join?

1 Answers  






How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


what are stage one indexable predicates?

1 Answers  


What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,


Can SQL statements/queries be included in a copybook?

2 Answers  


Request to database but database is not available so what is was abend is raised?

2 Answers   UST,


Categories