which index is good ctxsys.context/ctxsys.CTXCAT [message #640099] |
Wed, 22 July 2015 05:34 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
hi All,
I have table which contains billion records,there was no index on one column.
1)create table test1(id number,name varchar2(250);
2)i inserted 5 million records in the above table.
3)Now i ran the query as below
select * from test1 where name like '%raj%';
it is going for full scan and executing more than 5 hours.
4)Now i tried to create index on this column using the below index
create index i_indexname on test1(name) indextype is ctxsys.context
Now i got output with in 15 minutes.
But is there any problem by using above index in Database side.
otherwise can anyone suggest any other method to implement the same.
Regards,
rajesh
|
|
|