|
|
Posted by bhushanvinay on 06/25/06 02:13
i have a single souce table , Table a With contiains records for two
different entries for the same vendor by different accounting
instructions,
BidId = 10,Person Name=ABC,PersonBidAmt=$100
BidId = 11,Person Name=ABC,PersonBidAmt=$110
now the recors are to be shown as
Original Rcds Vs IntutiveRecords
OrName,OrAmt,IntName,IntAmt
ABC,100,ABC,110
for this reason i use
Select A.name,A.Amt,B.name,B.Amt
from A
leftOuterjoin B -- There are many reasons why i do a left outer join
because i may not have the record in the b side at all
but this is causing a very big performence issue as this view is very
huge.31,000 records on each side is taking 2 minits to work.
Could any one help me with this.
Navigation:
[Reply to this message]
|