« Technical Interview & Viva Questions : KyaPoocha.com home page
« What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible ?
When is the skeleton cursor table created ? »



Where is the access path logic created by the DB2 Optimizer stored ?


The access path logic is stored as skeleton cursor tables in the SCT02 Directory table.



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is RUNSTATS ?
    • A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer...
  • What is EXPLAIN?
    • EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement.  It can be...
  • Why use RUNSTAT Utility ?
    • Because the DB2 Optimizer need accurate data in order to formulate the most efficient access path given the state of...
  • What will the DB2 optimizer do ?
    • The optimizer is a DB2 component that processes SQL statements and selects the access paths....
  • What is a bind?
    • Binding is a process that creates the access path logic for the sql statements within a cobol program. after precompilation...
  • What are OPTIMIZER HINTS ?
    • Specifies a hint string that Oracle Forms passes on to the RDBMS optimizer when constructing queries. Using the optimizer can...
  • 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....
  • What is a path ?
    • A path is a file that allows you to access a file by alternate index - the path provides an...
  • What is the function of Optimizer ?
    • The goal of the optimizer is to choose the most efficient way to execute a SQL statement....
  • What is Function of Optimizer?
    • The goal of the optimizer is to choose the most efficient way to execute a SQL statement....

    Comments are closed.