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!