Two tables vs one
20:42 25 Nov 2008

I have a table of music albums and a second of album art. Not every album has album art data so I need to do an OUTER JOIN between music and album art.

Both tables just contain ints and varchars, no blobs. Is it better to merge both tables into one to reduce the OUTER JOIN requirement?

database-design