Self join question

10 Aug 2006 2:53 PM

burt_king

We've got a self join on a table with a view of that table and two others.
Off the cuff, does anyone know if this is valid / not valid / a darn bad
idea.

The PeopleSoft software we're using does an update based on the results of
that view select statement and I'm seeing a lot of IS Table locks and I'm
wondering if the query optimizer is ticked off....

Many thanks.

--

10 Aug 2006 3:05 PM

Roy Harvey

On the most general level - because that is the level of the given
information - "a self join on a table with a view of that table and
two others" is not in and of itself a problem. Problems - if any -
are in the details of a specific case. It sounds as though you might
be having problems, but without details there is no way to even guess.

What I have seen is views written for one purpose being used for
another, and adding complexity that is not needed for the second case.
And I have seen very poor performance resulting from that sort of view
misuse.

Roy Harvey
Beacon Falls, CT

On Thu, 10 Aug 2006 07:53:01 -0700, burt_king <burt_k***@yahoo.com>
wrote:

Show quote

>We've got a self join on a table with a view of that table and two others.
>Off the cuff, does anyone know if this is valid / not valid / a darn bad
>idea.
>
>The PeopleSoft software we're using does an update based on the results of
>that view select statement and I'm seeing a lot of IS Table locks and I'm
>wondering if the query optimizer is ticked off....
>
>Many thanks.