Re: Remote view - who should create it? - discussion point!

Paul Smith doodled thusly:

>argument is correct. The administrator of the remote database won't let me
>create the view directly on his machine (which I think is the sensible way), but
>wants me to create it on MY machine....

the administrator of the remote database is (pick one or more):

1)thick as two bricks put together, 
2)doesn't have the foggiest what size tables you dealing with, 
3)an "OCP".

>1/ I am getting ORA-1652 errors - my TEMP tablespace is too small. - Since I
>don't know how much data will come back how can I sensibly pick a new datafile
>size?

Exactly. And a LOT more.

>2/ Surely the remote database is sending most of the information back to me to
>do the hard work if it is written in the second form - putting lots of data on
>the network.

You got it in one.

>3/ Would it not be sensible for the BIG database to handle the BIG query on it's
>tablespace as it would be better sized for it anyway.

Absolutely, assuming of course the result set would be smaller than the combined size of the intervening tables. Ie, no cartesian product queries.

>4/ With such a complex view, would it not be better on the remote machine for
>the purposes of the administration of bug fixes, changes etc. ( I didn't write
>the view in the first place! )

Not necessarily. But it would certainly be easier to tune.

>5/ Surely the remote database won't have to do much extra work to give me the
>required view. (One of the arguments for doing it on my database is that the
>remote system is already heavily loaded.)

Depends on how well indexes may be used and what size the result set is.

>
>I would be very interested to see what views (no pun!) you guys have on this
>issue. I you have probably guessed, I am trying to get the view made on the
>remote machine.
>

Keep insisting. Without any other qualifiers, that would be my first choice too.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Feb 05 2002 - 08:22:21 CST