General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
Thanks.
>>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
>
>Assuming your records aren't some huge structures, and assuming you aren't doing this with hundreds of tables all actively being accessed at once, then you can assume the table data will get cached into memory and you will have fast performance with or w/o indices. This is also assuming your application isn't already starved for memory.
>
>>
>>
>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only