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