select * from artist_name where id = (select name from artist_credit where id=621728);
select * from artist_name where id = (select name from artist_credit_name where artist_credit=621728);
Oliver Charles added a comment - 07/Nov/11 09:33 PM Do we gain a lot from this materialization? Is it best to fix the materialization, or replace it with a live view instead?
Oliver Charles added a comment - 10/Nov/11 12:42 AM Yes, but it can be used for sorting with a sub select and join too (which can be abstracted away with a view).
Bug
Closed
Normal
Incorrect artist_credit.name
Do we gain a lot from this materialization? Is it best to fix the materialization, or replace it with a live view instead?