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
Who is the owner of a schema in ms sql server?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is optimization and its types?
When does a workload on SQL Azure get throttled?
What do you know about system database? : SQL Server Architecture
What are the different types of replication you can set up in sql server?
what are database files and filegroups? : Sql server database administration
How to create an index on an existing table in ms sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is acid properties?
What is wide table?
Can you index views?
What are subquery and its properties?
What are the acid properties?
What are date and time data types in ms sql server?