Re: SQL Tuning

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 20 Apr 1999 02:51:07 GMT
Message-ID: <371de401.1289831@netnews.worldnet.att.net>

On Mon, 19 Apr 1999 22:35:04 GMT, karmst_at_usa.net wrote:

>One of the columns in the view is market_promotion_id. The result set returns
>25 records, but 10 of these contain the same market_promotion_id from the
>market_promotion table - this occurs because of the way joins returns multiple
>records from the other tables for the same market_promotion_id.
>
>Is there a way to return only 1 instance of market_promotion_id (i don't care
>which one), so that 9 out of 10 market_promotion_ids disappear.

You may not need to. Is this for a report? What tool are you using? I suggest trying to find a way to suppress the duplicate market_promotion_id values. With SQL*Plus, you would issue this command:

break on market_promotion_ids

regards,

Jonathan Received on Mon Apr 19 1999 - 21:51:07 CDT