Re: Using XML as a list in a MySQL Column

[Jonathon Coombes]

You are essentially looking at a 1:N relationship here with the artist_id join. The fact that you use ExtractValue() in the join condition will mean that index usage will be impossible and the join will be slower because of it. In a properly normalised form the Songs table will have multiple entries if there are multiple artist_id values for that particular song. That is, if there are 3 artists for a particular song, then 3 records will need to be created with duplicate values for a normalised relation.