I wouldn't know what to test, just wanted to know if someone can tell me why I should have an index under those circumstances as of now I'm not putting an index on that table.

If you meant test for speed then I guess I could test for that, I don't think I will see any major difference


>>Hello all,
>>
>>Is there a good reason to put an index on a table with few records, lets say max 100 records? Free table, no need to check for duplicates or referential integrity.
>>
>>Thanks.
>
>There's only one way to find out; test it.