Mark, thank you for responding. I ended up downloading FlameRobin and it does show computed indexes in the 'Index' tab as well as in the DDL, i.e.:

CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname));

P.S.  I found your response in my Google 'Sent' folder, it never made it into my inbox, but anyway, I am glad I located your message.

Why not use a case insensitve collation ?


see you !