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.
| Author |
Topic |
|
zippy
Yak Posting Veteran
69 Posts |
 Posted - 2001-10-09 : 03:26:29
|
| I was wondering how I could get the best peformance out of my database using tables and views.I don't know exactly how views work so I guess a bit of an explanation would be useful.I have the following tables, Country, Region, City, Suburb, BranchAll the tables are linked together, the region table contains and ID number which links back to the Country table and so on.Does using a view speed up access when I want to get values from each of the tables?Sorry if this is a bit incoherent, for some reason I cant seem to make myself make sense at the moment? no where did I put that hammer...Check out the worlds fastest computers at http://www.ocgurus.com |
|
|
|
|
|
Views vs Tables