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

What is SQL server agent?

2 Answers   HCL, SAP Labs,


What is the difference between local and global temporary tables?

0 Answers  


Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,


Wht is SQL Injection Attack ?

3 Answers  


What are the recovery models for a database?

0 Answers  






how you can get the list of largest tables in a database? : Sql server administration

0 Answers  


How make remote connection in database?

1 Answers  


How to modify an existing stored procedure in ms sql server?

0 Answers  


What is the use of tempdb? What values does it hold?

0 Answers   Abacus,


Explain the types of indexes.

0 Answers   Accenture,


Explain sql delete command?

0 Answers  


What is a performance monitor?

0 Answers  


Categories