Hi,
I am adding index's to a few fields in a tables that already exists & has done so for a long time, perhaps 5000 records
They are date fields, few questions.
1) Is the existing data automatically indexed once I change the setting in the table, I only say as when I added them & closed the table there was no delay.
If as I understand when using normally there can be a slight overhead in creating the index I would have thought indexing the whole table would at least be a half second or more.
2) Is there even the tiniest risk to the data being corrupted adding late on.
3) It is for a booking system, I have date in & date out. Lots of query that search &/Or add up who is in between those dates.
Do you think is better to have a multiple index or Indate & Outdate separately.
I will do lots of testing but good to get a handle on most likely to work fastest.
thanks I/A
I am adding index's to a few fields in a tables that already exists & has done so for a long time, perhaps 5000 records
They are date fields, few questions.
1) Is the existing data automatically indexed once I change the setting in the table, I only say as when I added them & closed the table there was no delay.
If as I understand when using normally there can be a slight overhead in creating the index I would have thought indexing the whole table would at least be a half second or more.
2) Is there even the tiniest risk to the data being corrupted adding late on.
3) It is for a booking system, I have date in & date out. Lots of query that search &/Or add up who is in between those dates.
Do you think is better to have a multiple index or Indate & Outdate separately.
I will do lots of testing but good to get a handle on most likely to work fastest.
thanks I/A