Re: Performence issue

On 24 Jun 2006 19:16:40 -0700, "Vinay Bhushan" <bhushanvinay_at_gmail.com> wrote:

>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.

31000 records is not huge, it is a joke. As many people before you provide insufficient details, so you probably won't get any responses.
My bet would be the outer join is causing this, but without an explain plan it is difficult to tell.
Queries running for 2 minutes don't necessarily constitute a performance issue. They might if they are running every 2 seconds. If they are not: no performance issue.

--
Sybrand Bakker, Senior Oracle DBA