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.

[Back to original message]