Split your metadata from your files, and suddenly your sluggish document system becomes fast, scalable and surprisingly cheap to run.
RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from ...