Re: View hangs up

Jon Pilarski wrote:
>
> Can someone help with this one???
>
> When I select from this view, occassionally
> it hangs up indefinetely. The base tables
> are pretty small and I thought a primary
> key constraint on the two base table might
> be the problem but I dropped them and still
> get hung up.
>
> Any clues to possible DBA system settings
>
> Thanks in advance
>
> Jon Pilarski
>
> ---------------------------------------------------------------

Is the view doing any group bys? subqueries? Can you select off the tables that are in the view?

Bess Received on Tue Mar 26 1996 - 00:00:00 CET