Plex 2E

  • 1.  How do I create a encoded vector index (EVI) using plex6.1  Iseries db2?

    Posted Dec 09, 2014 03:23 AM

    Hi,

     

    I am trying to increase performance of sql queries.

     

    When using the system I navigator and under performance tools  they suggests me to create a EVI index based on a table.

     

    How do you create a encoded vector index (EVI) using plex6.1  Iseries db2? What will the triples be that you specify when creating a view to create a encoded vector index instead of a binary radix index.

     

    Thanks



  • 2.  Re: How do I create a encoded vector index (EVI) using plex6.1  Iseries db2?
    Best Answer



  • 3.  Re: How do I create a encoded vector index (EVI) using plex6.1  Iseries db2?

    Posted Dec 09, 2014 03:54 AM

    Thanks for your response,

     

    So what you are saying you cant create it using plex?



  • 4.  Re: How do I create a encoded vector index (EVI) using plex6.1  Iseries db2?

    Posted Dec 09, 2014 03:59 AM

    Exactly not in Plex...yet... idea wall...join the CA Plex r7.2: Agile collaboration registration is now open....



  • 5.  Re: How do I create a encoded vector index (EVI) using plex6.1  Iseries db2?

    Posted Nov 15, 2015 08:21 AM

    Community Webcast: CA Plex Support for Modernizing Your IBM DB2 for i (Nov. 12th)

     

    see StellaTools.IBMi.Examples.Modernization.Entity02.SQLEncodedVectorIndex01