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!