Complex Indexes

[lavoura]

Hello everyone,

Is it possible to create complex indexes in tables in EA?

I have an index like the one below:

CREATE INDEX NI_BILIT_1 ON BILLING_ITEM (FK_ACCNT_ID , STATUS , NVL(NET_VALUE , GROSS_VALUE) );

As you can see, the index uses an NVL function to decide whether it should use the NET_VALUE or GROSS_VALUE column.

I couldn't create an index like that in EA. So, here is my question: is it possible?

I'm using registered version of EA (to the Brazillian company I work for): 8.0.863

Cheers,
Lavoura