|Subject||Re: Composite vs single column keys|
> alter table gl add concat_key computed by (company || account || division ||I thought about something like that but these are all Varchar fields, so concatenating them together isn't going to work. I suppose that they could be changed to Char. I will have to play around with it to see if that will do what I want.
> create asc index ix_gl_concat on gl computed by (company || account || division
> || department);
> select * from gl where concat_key > ('CO' || 'ACCT');