Re: How do I set up a Single concatednated index?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Fri, 05 Feb 1999 14:43:30 -0800
Message-ID: <36BB7411.60FAFD01@us.oracle.com>

create index index_name on table_name (column1, column2, column3) + whatever other parts of the create index statement you might like.

HTH Pete

"Thomas W. Motyka" wrote:

> I need to set a single concatenated index....how do I do that???
> I have several fields in a table that I string together to make one field
> that my users can do a search on..... this search takes a long time....I was
> told that I need to set up a single concatenated index on these fields that
> I am stringing together.....
>
> Tommy
> motykat_at_hotmail.com

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Fri Feb 05 1999 - 16:43:30 CST