What is index segmentation?

          

Interview questions

What is index segmentation?

<<Previous   Next>>

Sql server   - What is index segmentation? - March 31, 2010 at 19:10 PM by Vidya Sagar

What is index segmentation? 

A segment is a part of relational data base and consists of one or more extents. Each extent is further divided into blocks. Every segment has an index for holding all of its data for quick data retrieval. Index segments can be created explicitly by using the CREATE INDEX command. Storage parameters for the extents of the index segment can be specified along with this command. 

<<Previous   Next>>
SQL Server backup devices and methods

Explain the backup devices offered by SQL Server 2000. [Hint Disk devices, Tape Devices, Named pipe devices], Database backup methods, Full Backups, Differential Backups, Transaction Log Architecture Backups, File and Filegroup Backups..............

SQL Server Data manipulation

Define Data manipulation language, Explain the command Select, Insert, Update and Delete with syntax.............

Describe in brief SQL Server monitoring ways.

SQL Server caches the plan of execution of query or stored procedure which it uses in subsequent call. This is a very important feature with regards to performance enhancement. You can view execution plan of data retrieval graphically or textually................

How to alter a user-defined data type?

The only way to alter a User Defined Data Type is to drop the existing and create a new one...........



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring