Teradata Database concepts Interview questions
1.What is RDBMS?
2.What is referential integrity?
3.What are ACID properties?
4.What is a transaction?
5.Relate atomicity in transaction definition?
6.What is a primary key?
7.What is a foreign key?
Showing posts with label database interview. Show all posts
Showing posts with label database interview. Show all posts
Difference between Index defrag and index rebuild
Difference between Index defrag and index rebuild
When you create an index in the database, the index information used by queries is stored in index pages. The sequential index pages are chained together by pointers from one page to the next. When changes are made to the data that affect the index, the information in the index can become scattered in the database. Rebuilding an index reorganizes the storage of the index data (and table data in the case of a clustered index) to remove fragmentation. This can improve disk performance by reducing the number of page reads required to obtain
the requested data
DBCC INDEXDEFRAG - Defragments clustered and secondary indexes of the
specified table or view.
When you create an index in the database, the index information used by queries is stored in index pages. The sequential index pages are chained together by pointers from one page to the next. When changes are made to the data that affect the index, the information in the index can become scattered in the database. Rebuilding an index reorganizes the storage of the index data (and table data in the case of a clustered index) to remove fragmentation. This can improve disk performance by reducing the number of page reads required to obtain
the requested data
DBCC INDEXDEFRAG - Defragments clustered and secondary indexes of the
specified table or view.
Subscribe to:
Posts (Atom)
