What is an Index Segment ?

Answer Posted / nishi

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I create database in oracle?

559


How to check database size in Oracle?

633


What is the Tune Query

1837


Explain the use of owner option in exp command.

566


Explain what are clusters?

608






What are the uses of Database Trigger ?

1097


Explain the difference between sql and oracle?

574


Explain the use of grant option in imp command.

574


What is the quickest way to fetch the data from a table?

562


Explain what are synonyms used for?

600


What is difference between cartesian join and cross join?

582


What is a snapshot log?

557


What is different types of joins?

570


How to write a query with a left outer join in oracle?

599


How much memory your 10g xe server is using?

578