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
- Add new comment
- 12 views