[askdba] Re: lot of time taking on qa than production
- From: "Abraham Kurian" <kurian24@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Sat, 9 Aug 2008 18:34:27 +0530
See what changed in the execution plan , 10053 will be a good starting
point
Thanks
Kurian
On 8/8/08, drumil narayan <drumilnarayan@xxxxxxxxx> wrote:
>
> Our production and qadatabases are same in structure and hardware.
>
> following query is taking approx 2 minutes to fetch about 4568878 where as
> am firing the same query on qa it is still running.
> no of indexs and columns are identical on the both the databases..where
> should i look for..
>
>
>
> select m.sic_code sic_code from
>
> zips z,
>
> addresses a,
>
> memberships m,
>
> territorys t
>
> where m.MEM_SOURCE != 'MCCOY NOM'
>
> and m.mem_type = 'GOV'
>
> and ((m.CANCEL_TYPE IS NULL OR m.CANCEL_TYPE IN('REINSTATE','EXTENSION') OR
> m.CANCEL_TYPE LIKE 'PO%') OR SYSDATE - m.CANCEL_DT < 366)
>
> and m.mem_id = a.mem_id
>
> and a.addr_type ='BUS'
>
> and a.zip_code = z.zip_code
>
> and substr(lpad(to_char(abs(z.zip_code)),9,'0'),1,5) = t.zip_code
>
> and z.state=t.state
>
> and z.county=t.county_code
>
>
>
> thanks
>
> ------------------------------
> Did you know? You can CHAT without downloading messenger. Click
> here<http://in.rd.yahoo.com/tagline_webmessenger_2/*http://in.webmessenger.yahoo.com/>
>
Other related posts:
