Search a row by Primary Key

[SnehaAgrawal]

Hi,
I have a table with 1000 records..I want to serach a row or want to go to a particular record...If I go by normal proc. I m sure it wud be a table scan I want to know is it possible by using indexing or primary key to go yo a particular record?If yes then how?

[iburyak]

Hi,
I have a table with 1000 records..I want to serach a row or want to go to a particular record...If I go by normal proc. I m sure it wud be a table scan I want to know is it possible by using indexing or primary key to go yo a particular record?If yes then how?

If you have a correct index over primary key it should use it but on the other hand for 1000 rows server might choose table-scan because it is not much data to scan in a first place. Please, provide more details on table structure, index information and query you use.