Topic
  • 2 replies
  • Latest Post - ‏2014-03-16T19:13:01Z by NickLawrence
bjbbarker
bjbbarker
20 Posts

Pinned topic EVI with include clause

‏2014-03-14T19:39:55Z |

Is anyone using an EVI index which has an includes clause?  Have you had any issues with it?

CREATE ENCODED VECTOR INDEX USERFILES_E1                       
ON USERFILES ( CUSTOMERID ASC )                                                  
INCLUDE (  SUM ( FILESIZE ) ) 
  • B.Hauser
    B.Hauser
    282 Posts

    Re: EVI with include clause

    ‏2014-03-16T10:15:28Z  

    I've used EVIs with INCLUDE clases, without any problems.

    Except the queries that can use those EVIs run very fast (even though there are millions or records within the base tables).

    Birgitta

  • NickLawrence
    NickLawrence
    69 Posts

    Re: EVI with include clause

    ‏2014-03-16T19:13:01Z  

    Not sure if you've seen it or not, but we published an article on this feature in developerWorks:

     http://www.ibm.com/developerworks/ibmi/library/i-accelerated-analytics-db2-evi-tech/index.html

    Updated on 2014-03-16T19:15:00Z at 2014-03-16T19:15:00Z by NickLawrence