How does one remove entries from the SCT02 table ?
Run the FREE PLAN command.
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
After a table is defined, can columns be removed ? 25.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...From where can you change the default port ? 24.07.08
From the Network Utility TCP/IP properties –> Port number.both on client and the server. Can you tell me the difference between DELETE & TRUNCATE com...After a table is defined, can columns be removed ? 14.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...Where is the access path logic created by the DB2 Optimizer stored ? 12.04.08
The access path logic is stored as skeleton cursor tables in the SCT02 Directory table....What is Skeleton cursor table (SKCT) ? 24.03.08
The Executable form of a Plan. This is stored in sysibm.sct02 table....How virtual functions are implemented C++? 03.05.07
Virtual functions are implemented using a table of function pointers, called the vtable. There is one entry in the table per virtual function in the class. Thi...What are Hashed Tables? 15.04.07
Hashed tables - This is the most appropriate type for any table where the main operation is key access. You cannot access a hashed table using its index. The re...How data is stored in cluster table? 10.04.07
Each field of cluster table behaves as tables, which contains the number of entries....What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table. 16.11.06
Drop Table - will remove the existence of the table from the database along with its data and structure and all the constraints. The table will be no longer ava...How could I get distinct entries from a table? 06.08.06
The SELECT statement in conjunction with DISTINCT lets you select a set of distinct values from a table in a database. The values selected from the database tab...