Multi Column Datastore [message #110453] |
Mon, 07 March 2005 15:00 |
verynewtothis
Messages: 11 Registered: March 2005 Location: Washington DC Metro Area
|
Junior Member |
|
|
I already have a CONTEXT index using a direct datastore on one column of data. I want to try creating a CONTEXT index on the same data, but I would like to index that data on more than one column (i.e. using a multi column datastore).
Q1) I know that I need to preceed index creation with the following code, for example:
begin
ctx_ddl.create_preference('my_alias', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute('my_alias', 'column', 'column1 "column1", column2 "column2", column3 "column3"');
end;
But when I create the index and specify which column to index the table on, do I use 'my_alias' as the column name during index creation
i.e. CREATE INDEX ex_idx ON table1('my_alias')...
Q2) Then, to utilize the multiple columns that, would hopefully be indexed on, I am wondering if within a CONTAINS clause that I can list the columns that are indexed that I want to query against and the parameter I am searching for
i.e. WHERE CONTAINS(table1.name, 'ralph', table1.age, '25', table1.lastName, 'smith') > 0
IS this the correct syntax, or can you point me to what would be the correct syntax?
|
|
|