Tag Info

New answers tagged

1

Are you using Enterprise Edition? It looks like this is a EE feature: http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm CTRL + F the docs and search for result cache and supported editions.


1

How about an indexed view? CREATE VIEW dbo.LoginsByDate WITH SCHEMABINDING AS SELECT UserID, LoginDate = CONVERT(DATE, LoginDate), LoginCount = COUNT_BIG(*) FROM dbo.LoginTable GROUP BY UserID, CONVERT(DATE, LoginDate); GO CREATE UNIQUE CLUSTERED INDEX IX_LoginsByDate ON dbo.LoginsByDate(UserID, LoginDate); GO What this does is ...



Top 50 recent answers are included