Posted by Erland Sommarskog on 06/25/06 08:25

(bhushanvinay@gmail.com) writes:
> 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.

No, you can't expect to get any help with the information you have
provided. For starters, post the actual query and also the CREATE
TABLE and CREATE INDEX statments for the table(s) in question.

Could you also clarify: is there 31000 rows in the table totally,
or does the query return 31000 rows?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: T-SQL Problem - should I use the "ALL" clause?
• Prev in forum: Re: The single OS nature of MS SQL
• Thread view: Re: I have a question With Related to performence

[Reply to this message]