Book a Demo

Author Topic: Create Function Based Index in Database Model  (Read 3037 times)

Victor Conovalov

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Create Function Based Index in Database Model
« on: October 30, 2009, 12:04:41 am »
Hello All,
I did not find the way how to create Function Index for table (Oracle), instead of simple index on column in EA.
For Example: I define simple index on Col1 in Table1.
The EA generate sql script:
create index INDX_COL1_TABLE1 on TABLE1(Col1)
but I want to have function based index (UPPER function) on my column:
create index INDX_COL1_TABLE1 on TABLE1(UPPER(Col1))
How to do it in EA?