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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-08-15 : 10:05:02
|
| Hi,I have three tables employee, department and person. I do a inner join on employee and department tables to get the relavent information. I want to get ssn# from person table only if it is stored in the table - I do left outer join on person table. Since each of the tables have 2 million rows, I am wondering if I can eliminate left outer join and use an inline view in the query.select e.empname, d.departmentname, p.ssn, p.dobfrom employee e inner join department don e.emp_id = d.emp_idleft outer join person p on p.emp_id = e.emp_idOn general terms what is the advantage and purpose of using inline view.Any suggestions and inputs would help.Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-15 : 10:07:37
|
Inline View ? What's that ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Inline views