oracle - search query

[raaam]

hi all,

i have a table student_tbl in oracle and it have lacks of studends records

i want to search few students of records from that table.... now i using simple query

select * from student_tbl where st_name="fdds" and last_name="dfdfd"
but its take more time for searching the result....

i want to quick search....

i want to change that query for speedy process

is anybody know?

plz give that solution......

thanx in advance......

[NogDog]

I don't see any way to optimize what is a simple query to begin with. All I can suggest is to modify your database to add indexing to the st_name and last_name columns if they are not already indexed or the primary key.