Re: Help needed for SQL Tuning...

From: franck <francois.bourdages_at_harfan.com>
Date: 22 Jun 2006 04:52:59 -0700
Message-ID: <1150977179.647626.61710@y41g2000cwy.googlegroups.com>

It is true , if there is no PK-FK relationship between rollcol in tables defn_tbl
and supp_sec_tbl. In this case, YES all rows descr in supp_sec_tbl that don't have correspondant in defn_tbl will be set to a null descr.

But If defn_tbl is a lookup table for rollcol in supp_sec_tbl, with pk-pk relation, all rollcol in supp_sec_tbl will be in defn_tbl. In this case only , you do not need your exist clause.

Sorry for the assumption. I tought that ou had this relation, and you wanted to denormalize a bit. Received on Thu Jun 22 2006 - 06:52:59 CDT