Re[2]: Help with SQL

[Bill Bowers <bowersb@PSPH.PROVIDENCE.ORG>]

     Index information:

     ps_employment:  emplid, empl_rcd#

     ps_pay_earnings: company, paygroup, pay_end_dt, off_cycle, page#,
     line#, addl#

     ps_pay_oth_earns:company, paygroup, pay_end_dt, off_cycle, page#,
     line#, addl#, erncd

     My e-mail address is bowersb@psph.providence.org

     Thanks!


______________________________ Reply Separator _________________________________
Subject: Re: Help with SQL
Author:  SQR-USERS@USA.NET at INTERNET
Date:    1/5/98 2:43 PM


What are your indexes on these 3 tables?
   1) ps_pay_oth_earns
   2) ps_employment
   3) ps_pay_earnings


> ----------
> From:         Bill Bowers[SMTP:bowersb@PSPH.PROVIDENCE.ORG]
> Reply To:     SQR-USERS@USA.NET
> Sent:         Monday, January 05, 1998 2:54 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Help with SQL
>
>      I am running the following sql within an sqr and it runs, and
> runs and
>      runs.  Anybody (familiar with PeopleSoft) have any ideas?
>
>
>      select
>       c.deptid,
>       q.union_cd,
>       b.pay_end_dt,
>       b.erncd
>       sum(b.oth_hrs),
>       sum(b.oth_pay)
>       from ps_pay_oth_earns b, ps_employment q, ps_pay_earnings c
>       where b.pay_end_dt between '01-JAN-97' and '31-DEC-97'
>       and b.company = c.company
>       and b.paygroup = c.paygroup
>       and b.pay_end_dt = c.pay_end_dt
>       and b.page# = c.page#
>       and b.line# = c.line#
>       and b.addl# = c.addl#
>       group by c.deptid,
>                 q.union_cd,
>                 b.pay_end_dt,
>                 b.Erncd
>
>      Thanks in advance
>
>      Bill Bowers
>      St. Peters Hospital
>      Olympia, Washington
>      (360) 393-5437
>