Index created for product lookup in Quotes module

Due to a client of ours having 200K products listed (table [aos_products]), we created the following index that improves the user experience during quotes creation, because of slow (non-index) lookup of products by name:

CREATE INDEX aos_products_idx_name
ON aos_products (name ASC)
COMMENT ‘Improves performance during product lookup in quotes’

Hope this helps you!

1 Like

This index should be added by default into Products. Can you please suggest them here.

Done !