Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  do views save time?

Author  Topic  paul13 Starting Member 17 Posts Posted - 2001-04-20 : 21:02:43 I am working with a table that has about 100 entries per day since 01/01/1999. I have to run a series of queries against the table that all deal with information from just a single month's entries. will making a view of the table that just points to the entries for the dates i am querying save me time, or would i be better of making a temporary table? I am more concerned with the time problems that may come up in 5 years when the table s 3 or 4 times the size. I will run some timers to check both, but I was just wondering if anyone new anything I should know. the table is indexed. paul13