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

how many bits ip address consist of? : Sql server database administration

0 Answers  


What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  


How to create a new table in a given schema?

0 Answers  


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  


What is exclusive locks?

0 Answers  






What are exact numeric data types in ms sql server?

0 Answers  


What is the difference between resultset and resultsetmetadata?

0 Answers  


how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,


What is the difference between composite index and covering index?

0 Answers  


What is the recursive stored procedure in sql server?

0 Answers  


What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,


Explain how to send email from sql database?

0 Answers  


Categories