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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-14 : 08:06:44
|
| Annie writes "I wanted to know how I can retreive data from 10 tables simultaneously. Can I use a view to achieve this or is there any other way for this ?All the 10 tables contain a huge amount of data and 2 tables contain 32 columns. What is to be done so that I can retreive data from 10 tables and at a considerable speed -each table has a joining common column?" |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-02-14 : 15:58:10
|
| You can join all of the tables together either by themselves or in a view.From a performance viewpoint, it would help if you only returned the data columns that were necessary, if you had the proper indexing on the joining columns and if you applied the correct filtering in the where clause.HTH=================================================================Egotism is the anesthetic that dulls the pain of stupidity. -Frank William Leahy, football coach (1908-1973) |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-02-15 : 21:28:30
|
| >>I wanted to know how I can retreive data from 10 tables simultaneouslyWhy :) I mean what are you doing with 10 big tables of data that require you to access them concurrently? |
|
|
|
|
|
|
Using a view to retreive data from 10 tables