Indexing using vb6 and sql server 2000

Submitted by vahiduddin on

i have a table by name item_code which have huge data like 200,000 records in it when i try to search it take too long to search a particular record i need to do indexing by which it will search faster can any one help me out in this i need the code for doing the indexing so that it searches fast and give result soon

table structure is

Icode varchar(20)
Iname varchar(50)
Idesc