Delphix Products

  • 1.  Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 02:29:00 PM
    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
    #Virtualization


  • 2.  RE: Benefits of Indexes in case of Virtual DBs
    Best Answer

    Posted 11-05-2018 02:45:00 PM
    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


  • 3.  RE: Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 02:49:00 PM
    Hi Mayank,

    The advantages and disadvantages of indexes are the same for physical and virtual databases - the database logically stores data the same way for both (the database doesn't know whether it is a VDB or a physical).

    You are correct in that the blocks are physically stored differently but as far as the database is concerned, the path to those blocks is the same.


  • 4.  RE: Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 02:53:00 PM
    Thanks Matt. I understand that, my question is that does the path really matter from a DB point of view, because eventually the blocks are physically stored elsewhere ?



  • 5.  RE: Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 02:59:00 PM
    Thanks Neal


  • 6.  RE: Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 03:19:00 PM
    Mayank, it's no difference.  Database files could be on locally attached storage, a SAN, a NAS...even in the cloud.  Indexing approach and benefits are the same.  Indices allow you to do the same work with fewer block fetches for most types of workloads....faster performance.


  • 7.  RE: Benefits of Indexes in case of Virtual DBs

    Posted 11-05-2018 03:33:00 PM
    Thanks Ranzo !!