What is Index Segmentation ?



What is Index Segmentation ?..

Answer / hari krishna

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.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,


What is the difference between temp table and table variable?

8 Answers   Microsoft,


What is a raid and what are different types of raid configurations?

0 Answers  


what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  


What are the components of dbms?

0 Answers  






Can we use where and having clause together?

0 Answers  


What is indexing in sql server with example?

0 Answers  


What is a trigger what are the advantages of trigger?

0 Answers  


What is the significance of master, tempdb and model databases?

0 Answers  


How do you Implement SSIS Packages in your Project?

0 Answers  


What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,


what is a deadlock? : Sql server database administration

0 Answers  


Categories