Subject | Re: Composite vs single column keys |
---|---|
Author | sboydlns |
Post date | 2010-08-25T15:27:28Z |
> 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.
> department);
>
> create asc index ix_gl_concat on gl computed by (company || account || division
> || department);
>
> select * from gl where concat_key > ('CO' || 'ACCT');
>