This may seem silly, but in trying to stick to my standard nomenclature when naming indexes in our DB, the latest one was a little lengthy, and like all things DB I wondered if it in any way could negatively affect performance. I'm just not sure where or how index names are actually stored or used vs the actual column data.
For example, is it advantageous to name an index epoid vs ecm_products_options_product_id?
The later has been closer to our standard and makes for easier reading and identification in the application layer.
Aucun commentaire:
Enregistrer un commentaire