Briefly describe what is index organized table in types of segments In an index

Briefly describe what is index organized table in

This preview shows page 2 - 4 out of 5 pages.

3: Briefly describe what is index organized table in types of segments?
Image of page 2
4: Briefly describe what is index partition in types of segments? 5: Briefly describe what is undo segments? 6: Briefly describe what is temporary segment?When a user executes a command such as CREATE INDEX, SELECT DISTINCT, and SELECTGROUP BY, the Oracle server tries to perform sorts in memory.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 5 pages?

  • Summer '19
  • Oracle Database, Oracle Corporation

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture