Re: Help improving query performance

2015-02-04 Thread shawn l.green
Hello Larry, On 2/4/2015 3:37 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green wrote: Hi Larry, On 2/4/2015 3:18 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green wrote: Hi Larry, On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries.

Re: Help improving query performance

2015-02-04 Thread Larry Martell
On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green wrote: > Hi Larry, > > > On 2/4/2015 3:18 PM, Larry Martell wrote: >> >> On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green >> wrote: >>> >>> Hi Larry, >>> >>> >>> On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries. One takes 4 hours

Re: Help improving query performance

2015-02-04 Thread shawn l.green
Hi Larry, On 2/4/2015 3:18 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green wrote: Hi Larry, On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries. One takes 4 hours to run and returns 21 rows, and the other, which has 1 additional where clause, takes 3 minutes a

Re: Help improving query performance

2015-02-04 Thread Larry Martell
On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green wrote: > Hi Larry, > > > On 2/1/2015 4:49 PM, Larry Martell wrote: >> >> I have 2 queries. One takes 4 hours to run and returns 21 rows, and >> the other, which has 1 additional where clause, takes 3 minutes and >> returns 20 rows. The main table being

Re: Help improving query performance

2015-02-04 Thread shawn l.green
Hi Larry, On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries. One takes 4 hours to run and returns 21 rows, and the other, which has 1 additional where clause, takes 3 minutes and returns 20 rows. The main table being selected from is largish (37,247,884 rows with 282 columns). Caching i

Help improving query performance

2015-02-01 Thread Larry Martell
I have 2 queries. One takes 4 hours to run and returns 21 rows, and the other, which has 1 additional where clause, takes 3 minutes and returns 20 rows. The main table being selected from is largish (37,247,884 rows with 282 columns). Caching is off for my testing, so it's not related to that. To s