Search in text
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Search in text

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Thumbs down 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!

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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)

  3. #3
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Think about Function Base Indexes?
    Nagesh

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  5. #5
    Join Date
    Jan 2000
    Posts
    387
    Thanks! Will read up on them and see if they will work for me! Any more advices? Or any examples? Thanks!

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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

  7. #7
    Join Date
    Jan 2000
    Posts
    387
    Thanks for all advices Does it mean that if i am using the like condition, there is no better way to improve the search??

  8. #8
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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

  9. #9
    Join Date
    Jan 2000
    Posts
    387
    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
  •  



Click Here to Expand Forum to Full Width