table join question

From: Terry St.Jean <xtstjean_at_attglobal.net>
Date: Wed, 15 Aug 2001 14:53:23 -0400
Message-ID: <uyze7.53442$TW.272452@tor-nn1.netcom.ca>

I have the following SQL:
select rev_pos_sales.STARTWEEK, rev_pos_sales.QTY, rev_pos_sales.RETTOTAL, rev_prod_hier.FRANCHISE_CODE, rev_prod_hier.FRANCHISE_NAME, rev_prod_hier.HO_PRODID, rev_prod_hier.ACTIVE, rev_prod_hier.PDES1, rev_prod_hier.HO_UPC, rev_store_hier.CUSTNUM from REV_PROD_HIER, REV_STORE_HIER ,REV_POS_SALES where rev_prod_hier.divid = 'REV1' and

 rev_pos_sales.upc = rev_prod_hier.upc and
 rev_pos_sales.afid = rev_store_hier.afid and
 rev_pos_sales.storenum = rev_store_hier.storenum and
 rev_pos_sales.startweek between '01-JAN-2000' and '20-JAN-2002'

Are the table joins done first or is the date range and divid = 'REV1' done first.
I'm just wondering what indexes to build over these tables.

Terry Received on Wed Aug 15 2001 - 13:53:23 CDT