Can we add new indexes to the CatalogProducts table?

Question

Hi,

We have a huge catalog (about 2 million products).

There will be many searches based on an integer filed that is not (and I don’t know how to) indexed by commerce server catalog schema manager.

Can I just directly expand existing or create new indexes on the CatalogProducts table using sql server management studio? Is this a common or good practice?

Thank you,

Allan

Answer 1

Hi,

You can add your own indexes and you should do it :) that's one of the key success for performance :)

---

follow me on twitter @GaelDuhamel or check out my blogs http://www.gaelduhamel.fr http://www.gaelduhamel.com

Answer 2

Thanks Gael,

I wonder if "Specification Searchable" property is related to this topic. Is "Specification Searchable" checkbox indexes the the property?

 

Thanks again,

Allan

 

Answer 3

For me it's not. It's just a property to help you when you want to retrieve the properties you want to search in your search engine.

So, if you want new indexes you have to do it by yourself.

---

follow me on twitter @GaelDuhamel or check out my blogs http://www.gaelduhamel.fr http://www.gaelduhamel.com