Text Search ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Text Search ??

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    We are using database version 8.1.6 on NT 4. I am not aware of or do not know how to get Text serach without giving Field name. I mean in SELECT statement WHERE condition Like ' ' gives me Range search. But is it possible to Give only SEARCH TEXT and table name and will get exact record irrespective of Fields probably with Function.

    Thanks & Regards
    Shailesh

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Hmm, sounds like you are moving down the INTERMEDIA text indexing path. You can concatinate multiple colums into a single intermedia index. Then perform a 'WITHIN' select statment, to return all records which contain the criteria.

    Cheers
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    Originally posted by grjohnson
    Hmm, sounds like you are moving down the INTERMEDIA text indexing path. You can concatinate multiple colums into a single intermedia index. Then perform a 'WITHIN' select statment, to return all records which contain the criteria.

    Cheers
    Yes, you are right, Even I feel INTERMEDIA will help me in this. I don't have any Idea about InterMedia, can anybody help me in this.

    Thanks & Regards
    Shailesh

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Research this path FULLY, we found alot issues with intermedia. In regard to indexing, you have to set up DBMS_JOB (oracle recommend NOT using ctxsys, increases index fragmentation.. (adifferent fragmentation to normal indexes)) to SYNC and OPTIMIZE your indexes periodically.

    You have to tell Oracle when to index. You must consider two MAJOR factors before taking this path.

    a). How many columns are you looking to index, what is the volume.

    b). Is the system more OLTP or DSS.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80
    Originally posted by grjohnson
    Research this path FULLY, we found alot issues with intermedia. In regard to indexing, you have to set up DBMS_JOB (oracle recommend NOT using ctxsys, increases index fragmentation.. (adifferent fragmentation to normal indexes)) to SYNC and OPTIMIZE your indexes periodically.

    You have to tell Oracle when to index. You must consider two MAJOR factors before taking this path.

    a). How many columns are you looking to index, what is the volume.

    b). Is the system more OLTP or DSS.

    Cheers,
    hint is enough for me. Thanks grjohnson for valuable information.

    Regards
    Shailesh

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