trying to fully understand indexes in a table
Under a field's General properties in a table there is Indexed then I have it as default as Yes (No Duplicates)
recently I got an error when adding a field saying there was too many indexes for the table and I had to change the new field to no
Just to wrap my mind around this one, why would I want to index the field, is there much point to it? Am I increasing the performance, why is there a limit etc