Re: Slow Running Query
From: Jack Ploeg <jploeg_at_wxs.nl>
Date: Tue, 25 Aug 1998 14:38:59 +0200
Message-ID: <6rubb6$g8j$1_at_reader3.wxs.nl>
Date: Tue, 25 Aug 1998 14:38:59 +0200
Message-ID: <6rubb6$g8j$1_at_reader3.wxs.nl>
Hello Ed,
I think a full table scan happens, because sender or receiver columns in TABLE_A can be empty, and thus the unique index is not being used. You can check this by doing an explain plan (expain plan for select .... , the select statement you used to create your view).
You could try building a non-unique index on activity_date, or on activity_date, broker-id, if the broker ID is always known.
Gook Luck,
Jack. Received on Tue Aug 25 1998 - 14:38:59 CEST