CODEWITHSUNDEEP
mdriven
Jean-Philippe Golay
Jean-Philippe Golay

Reputation: 1

How to generate index in the Eco model

How to generate index in the Eco model, I need an extra search index on some table columns is it possible to ask model to generate them for me? ON SQLServer

Upvotes: 1

Views: 51

Answers (1)

Hans Karlsen
Hans Karlsen

Reputation: 2435

The script generator only adds indices for primary and foreign keys. You must add additional attribute indices manually in the DB. We had a wish to add this feature but to get good effect of indices one must include all the columns needed in a specific search - and the hints from a query optimizer helps you better.

Upvotes: 1

Related Questions