Answer: Here is a table that I will refer to during my answer:
RecNo cName nAge
----- ----- ----
1 Rick 34
2 Dan 30
3 Chris 33
An index is a logical reorganization of the data in a table. The record numbers do not change; the index just allows the table to be viewed in an order other than record number order. If I create an index on the cName field in the table above, here are the results:
RecNo cName nAge
----- ----- ----
3 Chris 33
2 Dan 30
1 Rick 34
Notice that even though Rick appears as the last record, it is still the first record in the table (Recno=1).
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
