Benefits of Indexes in case of Virtual DBs

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
Hi All,

I have a question on how indexing works on tables.

For instance if I am working on an Oracle DB, creating Indexes on columns speeds up the search because of how the data is stored in the DB.

However, in case of a Virtual DB, the data file doesn't reside on the DB server, instead the data i stored in storage attached to Delphix Virtualization Engine. In this case, does having Indexes on tables have the same or any impact to speed up the search on the tables ?

Regards,
Mayank
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 268 Points 250 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 2,902 Points 2k badge 2x thumb
Official Response
Hello Mayank,

You should consider a VDB the same as a physical database. Indexes should be created and maintained in a VDB just as you would for a physical database.

Thanks,
  Neal