By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

Search a row by Primary Key

P: 31
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?
May 1 '09 #1
Share this Question
Share on Google+
1 Reply


iburyak
Expert 100+
P: 1,017
@SnehaAgrawal
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.
May 11 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.