Question:The ITEM table has six columns. Since the table is often queried with a join to the SALE table, an index was created on five of the columns in the ITEM table. What will be the result?

a.        Inserts to the table will be slower
b.        The size of the ITEM table will be increased
c.        All queries on the ITEM table will be faster if it does not contain a large number of NULL values
d.        The speed of deletes will be increased

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.