I think I know the answer, but does Aurelius does support computed indexes? For example
CREATE INDEX IX_EMAIL ON USERS COMPUTED BY (upper('EMAIL'))
I guess this really needs to be done on the database, but just thought I'd check.
I think I know the answer, but does Aurelius does support computed indexes? For example
CREATE INDEX IX_EMAIL ON USERS COMPUTED BY (upper('EMAIL'))
I guess this really needs to be done on the database, but just thought I'd check.
Indeed, you will have to manually create such index in the database.