Keyword search ?

[Betty]

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

[nametullah]

Create the Index on the name field.

Regards,
Nametullah kalair