Search in text

[mooks]

Hi

I have a column which is used to store text... if i need to do a search in the text using like condition, it it very very slow... any ways of improving it?

Have tried to create an index on the text and it doesn't help much either... any help please?

Thank you!

[agasimani]

Install context/InterMedia cartridge. Read documents on this cartridge.

Checkout
http://otn.oracle.com/docs/products/...a77063/toc.htm

[gnagesh]

Think about Function Base Indexes?

[SANJAY_G]

Originally posted by gnagesh
Think about Function Base Indexes?

I don't think FBI will help in this particular situation, since he wants to use LIKE to search in the text.

[mooks]

Thanks! Will read up on them and see if they will work for me! Any more advices? Or any examples? Thanks!

[kgb]

If you want to make your own search system you can read this thread:

http://www.dbasupport.com/forums/sho...h+hash+cluster

I made search system based on hash clusters.

[mooks]

Thanks for all advices Does it mean that if i am using the like condition, there is no better way to improve the search??

[kgb]

You have to always look at execution plan.
create plan table and run:
set autotrace on explain;

if you use LIKE command, in most cases it always does full table scan.

[mooks]

Hi

I did an execution plan and the sql is already using index scan except for the like condition which is doing a full scan... any ways of improving it??