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.
Is This Answer Correct ? | 4 Yes | 1 No |
What is SQL server agent?
What is the difference between local and global temporary tables?
Explain the difference between delete,drop and truncate in SQL Server?
Wht is SQL Injection Attack ?
What are the recovery models for a database?
how you can get the list of largest tables in a database? : Sql server administration
How make remote connection in database?
How to modify an existing stored procedure in ms sql server?
What is the use of tempdb? What values does it hold?
Explain the types of indexes.
Explain sql delete command?
What is a performance monitor?