Keyword search ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Keyword search ?

  1. #1
    Join Date
    Feb 2004
    Location
    NYC
    Posts
    39

    Keyword search ?

    Hi DBAs,

    I have a SQL which does keyword search, like this:
    "select * from A where id =:1 and name = 'fisher';"
    Table A has millions of rows, if a user does any keyword search, such as 'fisher', the SQL has to scan every row in this table to get the rows with 'fisher', it costs long, long time.
    IS there anyone has good idea to make it faster?

    Thanks!

    Betty

  2. #2
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64
    Create the Index on the name field.

    Regards,
    Nametullah kalair
    Always Remember Power is Your.

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