Hi,
We have a customer running a Dynamicweb solution with more than 10.000 pages. It contains many websites and uses pages and paragraphs as items. The sites performed not so good. But after I added one none clustered index on the table Page with the fields PageItemType and PageItemId and another none clustered index on the table Paragraph with the fields ParagraphItemType and ParagraphItemId the sites performed much better. Before adding the indexes the SQL Server performed a lot of table scans on the tables Page and Paragraph when rendering a page. Is there any reason why these indexes should not be part of a standard Dynamicweb database?