Results 1 to 1 of 1

Thread: Request new Feature - Support Index expression

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,445

    Default Request new Feature - Support Index expression

    Most of DBMS (MSSQL, Db2, Oracle, MySQL, ...) supports index based on SQL expressions, instead of using full column content.

    This is an important feature, as the index is better used per application needs.

    DF Driver does not support such indexes yet.. I mean, you can create such indexes, and create filters using SqlFilters, but there are still space for enhancements.

    Filling grids for example, by using expression ordering matching the index definition.

    Basically, we need to be able to specify SQL expression on index keys segments, instead of just providing a column name.

    This is a Db2 example, of a index defined in a Json element:
    Code:
    CREATE UNIQUE INDEX "DB2ADMIN"."IX_CUST_STATE" ON "DB2ADMIN"."CUSTOMER_JSON"
        ( JSON_VALUE(JSON_DATA, '$.contact.state' RETURNING CHAR(2))        ASC, 
          "CUSTOMER_ID"                                                     ASC)
    But on DF layer, the first index segment is unknown..
    So, this index can`t be used by DF to perform finds or ordering.

    Click image for larger version. 

Name:	df_inxex_expression.PNG 
Views:	74 
Size:	62.6 KB 
ID:	14556

    The expression could be any SQL expression returning an scalar value.
    Regards
    Last edited by Samuel Pizarro; 25-Apr-2021 at 06:35 PM.
    Samuel Pizarro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •