MS SQL Data Warehousing

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Create View

Travis

2005-09-13, 3:23 am

Hi ,

If I create several views from the transaction table for reporting
purpose. Do the view occupy the disk space as well ?

--
Travis Tan

Danny

2005-09-14, 7:23 am

No. Unless it's an indexed view which contains data for the defined index.
Index views are sometimes used to speed up queries that require joins.

"Travis" <Travis@discussions.microsoft.com> wrote in message
news:0FD3F4E1-DFC2-42AB-8E29- 325438FFE11F@microso
ft.com...
> Hi ,
>
> If I create several views from the transaction table for reporting
> purpose. Do the view occupy the disk space as well ?
>
> --
> Travis Tan

Sponsored Links