What is Index Segmentation ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the uses of stored procedures.

573


How to declare and use cursor variables?

587


Do you know query execution plan?

588


tell me the disaster recovery plan

2026


What is factless fact table? : sql server analysis services, ssas

564






Define compound operators?

535


How to use group functions in the select clause in ms sql server?

538


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

705


What are the steps you must follow to hide sql server instances?

541


How to insert and update data into a table with "insert" and "update" statements?

512


Write a program using SQL queries to find a unique entry in a table.

547


What is a view and what are its advantages?

691


Using the customer, and order table in northwind database, please write a query to produce xml?

656


Why truncate is ddl command?

516


What are the types of joins in sql?

563