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

What are triggers in oracle?

747


What is the difference between sharding and partitioning?

711


What is a dead lock in oracle?

789


How to define a procedure inside another procedure?

727


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2131






Name the various constraints used in oracle?

773


What is bulk load in oracle?

809


What are the uses of linked server and explain it in detail?

791


What is ADDM Advisor in Oracle?

854


What is a Garbage Collection? and what is full recursive Garbage collection?

2575


Explain the use of record length option in exp command.

783


Describe the types of sub query?

729


Explain how are indexes update?

808


What do you understand by database schema and what does it hold?

908


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1757