Johan De Meersman wrote:
On Thu, Sep 17, 2009 at 3:46 AM, John Meyer <john.l.me...@gmail.com> wrote:
Alternatively, you can skip the A_ID and have a compound key of USER_ID and
A_NUMBER on the ASSOC_NUMBERS table. I prefer the A_ID, though.
Note that this would be marginally faster, because all your data is in
the index, so you don't need to do an additional lookup into the data
segment of your table.
And assuming that the numbers don't duplicate in your array.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
