|
|
|
|
 |
|
在祐 / 2008-09-18 / 오후 4:08:50 / 221.152.73.243
조회수 : 579
|
| [질문] 인덱스된 뷰 |
CREATE VIEW V_DreamCount_M WITH SCHEMABINDING AS
SELECT TOP 2 C_YEAR_N+C_Month_N+C_Day_N AS C_Date_N, COUNT_BIG (*) AS C_Count_N
FROM dbo.T_DreamCount_M
GROUP BY C_YEAR_N, C_Month_N, C_Day_N
ORDER BY C_Date_N DESC |
|
|
