Benefits of Indexes in case of Virtual DBs

  • 0
  • 1
  • Question
  • Updated 6 months 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 ?

Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,422 Points 3k 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.