Quote:
|
In the long run, though, you will surely get the best performance by adding an index on the CODE.CODE column.
|
Thanks. So it should be a 'unique' index correct?
I also find that the code table often needs to be 'optimized' because it has a little red in the overhead column under phpmyadmin but is this just to be expected with a table that's being written to and rows removed frequently?