Is It Safe To Create Index On Cscart_Products.product_Code?


I have an integration with cscart which retrieves data from cscart_products via product_code field.

I'm wondering if it's safe to create index on this field like that:

CREATE INDEX product_code_index ON cscart_products(product_code);

I've got following questions:

1) Will it cause trouble during feature cs-cart upgrades?

2) Will it also speed things up while searching via product_code from the admin panel?

3) Is it safe?

Thanks for the answers!

It should not cause a problem (unless you made it UNIQUE). Rarely are searches done by product code that are not done on other indexed columns so the performance improvement is probably negligible unless you have an extremely large products table or product_options_inventory table..