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 an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  


what is difference between having and where clause ?

3 Answers  


How do I debug a stored procedure in sql server?

1 Answers  


What stored by the tempdb ? : sql server database administration

1 Answers  


What happens if an integer is too big for int date type?

1 Answers  


How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,


What is the use of floor function in sql server?

1 Answers  


How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  


why would you call update statistics? : Sql server database administration

1 Answers  


last function used in MS Access to convert sql what function will use in sql

1 Answers   Cap Gemini,


What is the difference between referencing and joining?

1 Answers  


What is openrowset sql server?

1 Answers  


Categories