What is an Index Segment ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
Each Index has an Index segment that stores all of its data
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Give the constructs of a package, function or a procedure.
What is concurrency in oracle?
What is oracle sid?
What are the ways tablespaces can be managed and how do they differ?
What is an index associated with a constraint?
How to define a record variable to store a table row?
What is null value in oracle?
Can we create more than one index on particular column?
select * from emp what happened internally when we write this query in the sql prompt?
Why required to run root.sh at the time of installation and what exactly it will do
What is an Index Segment ?
what are bitmap indexes? How does they work?