What is Skeleton cursor table (SKCT)?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is check constraint in db2?

608


What is the syntax for creating a table in the db2 database?

627


what is the sqlcode -501

11301


What is collection in db2 bind?

577


What is a system catalog table in db2?

586






What is difference between isnull and coalesce?

620


How does coalesce work?

584


What is a bind card?

679


What is reorg and runstats in db2?

694


How do I start db2 in windows?

563


What is isolation level in db2?

577


How do you select a row using indexes in db2?

645


Is it possible using max on a char column?

607


what is a corelated subquerry?

658


What is the syntax for FETCH in DB2 ?

673