Lot of updates have been done on a table due to which indexes have gone haywire. What do you do ?
Looks like index page split has occurred. DO a REORG of the indexes.
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
What type of Indexing mechanism do we need to use for a typical datawarehouse ? 23.09.08
On the fact table it is best to use bitmap indexes. Dimension tables can use bitmap and/or the other types of clustered/non-clustered, unique/non-unique indexes...When do we use the UPDATE_STATISTICS command ? 24.07.08
This command is basically used when we do a large processing of data. If we do a large amount of deletions any modification or Bulk Copy into the tables, we nee...How can I perform a nonlogged bulk copy ? 22.07.08
The following conditions should be met for nonlogged bulk copy: The database option select into/bulkcopy is set to true using sp_dboption. The target table...How can we plan storage for very large tables? 23.05.08
Limit the number of extents in the table Separate the Table from its indexes Allocate sufficient temporary storage...List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance ? 08.05.08
SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operat...How does DB2 use multiple table indexes ? 01.04.08
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR....How many clustering indexes can be defined for a table ? 18.03.08
Only one....What is RIP (Routing Information Protocol)? 20.02.07
The Routing Information Protocol, or RIP, as it is more commonly called, is one of the most enduring of all routing protocols. RIP sends routing-update messages...What are indexes? 12.03.06
Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field...What is the use of INDEXES option in EXP command ? 12.03.06
A flag to indicate whether indexes on tables will be exported....