« Technical Interview & Viva Questions : KyaPoocha.com home page
« List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend?
How will you estimate the space required by non-clustered tables? »



How can we plan storage for very large tables?


Limit the number of extents in the table
Separate the Table from its indexes
Allocate sufficient temporary storage



Explore posts in the same categories: SQL Interview Questions


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

Related Questions :

  • What are the advantages of using a PACKAGE ?
    • The advantages of using PACKAGE are: 1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid...
  • What is the significance of having storage clause?
    • We can plan the storage for a table as how much initial extents are required, how much can be extended...
  • What is Virtual Memory?
    • Virtual memory is a concept that, when implemented by a computer and its operating system, allows programmers to use a...
  • When do we use the UPDATE_STATISTICS command ?
    • This command is basically used when we do a large processing of data. If we do a large amount of...
  • How would you go about generating an EXPLAIN plan?
    • Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement....
  • Explain what a plan is?
    • Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a...
  • What happens to the PLAN if index used by it is dropped ?
    • Plan is marked as invalid. The next time the plan is accessed, it is rebound....
  • What are Hashed Tables?
    • Hashed tables - This is the most appropriate type for any table where the main operation is key access. You...
  • Assuming that a site’s standard is that pgm name = plan name, what is the easiest way to find out which
    • Query the catalogue tables SYSPLANDEP and SYSPACKDEP....
  • What else is there in the PLAN apart from the access path ?
    • PLAN has the executable code for the SQL statements in the host program...

    Comments are closed.