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 |
How to create dbo table in sql server?
What is the difference between varchar and nvarchar?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What is merge join?
what is hash table
Explain the use of keyword with encryption. Create a store procedure with encryption?
Can a table have 2 foreign keys?
What is join and name different type of joins?
Explain the various types of concurrency problem?
How do database indexes work?
Explain about SQLOS?
What are points to remember while using the fillfactor argument?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)