I have a pretty standard database schema here with the primary key prod_id
being my most often used join column in select queries. Categories, rankings
.. just about anything having to do with products uses prod_id in a join,
and user access on these queries is pretty heavy.
I wonder whether the p
I learned that there are three types of indexes (PRIMARY, UNIQUE, and
INDEX).
Now assuming I create a performance-critical PRIMARY key, will I better have
to specify UNIQUE and INDEX for this column also !? It should be obvious
that a primary key is unique anyway, and an index as well, shouldnt it
