We just upgraded a large site (over 9,000 documents) from 2.1d to 2.1e to 2.2 and then to 2.3 - when we upgraded to 2.3 we started experiencing 1 minute 40 second times on this query:
SELECT * FROM View_PageInfo
WHERE ((NodeSiteID = 1)
AND ((NodeAliasPath = N'/'
AND (DocumentCulture = N'en-US'))
OR (DocumentUrlPath = N'/')))
ORDER BY DocumentUrlPath ASC
in 2.2 this query time was 0.4 seconds... do you have a solution for this?