Performence issue

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

Ihave more than 250 columns on each side A.250 cols and B.250 cols. I have checked with indexes on the tables are are fine

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. Received on Sat Jun 24 2006 - 21:16:40 CDT