-
Search in text
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!
-
Install context/InterMedia cartridge. Read documents on this cartridge.
Checkout
http://otn.oracle.com/docs/products/...a77063/toc.htm
Agasimani
OCP(10g/9i/8i/8)
-
Think about Function Base Indexes?
Nagesh
-
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.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Thanks! Will read up on them and see if they will work for me! Any more advices? Or any examples? Thanks!
-
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.
Best wishes!
Dmitri
-
Thanks for all advices Does it mean that if i am using the like condition, there is no better way to improve the search??
-
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.
Best wishes!
Dmitri
-
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??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|