It's measurably more maintainable to create the view against the table. Any
time you modify a form, the views that ARS creates on top of the tables is
dropped and recreated. This is because there is no way in the db to alter
the view. When the view is dropped and recreated it may invalidate the view
you have that is built on top of that view, esp if the owner of the view is
not the ars db account.
I've found that it's best not to create or alter objects in the ars schema.
They tend to turn into something that resembles space debris after a while.
On Mon, Jan 24, 2011 at 4:22 PM, Roberts, Chas <
crobe...@riversidecountyit.org> wrote:
> Sort of depends if you want to wait for the view to be processed before the
> view of the view.
>
> It's probably measurably more efficient to create the view(let) from the
> original table.
>
> Chas
>
>
>
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
> Sent: Monday, January 24, 2011 2:07 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: View of a View?
>
> So is it recommended?
>
> Lisa
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
> Sent: Monday, January 24, 2011 5:05 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: View of a View?
>
> On Oracle, the optimizer will convert the view (through the other view)
> down to the actual table when it executes the query.
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
> Sent: Monday, January 24, 2011 3:50 PM
> To: arslist@ARSLIST.ORG
> Subject: View of a View?
>
> **
> I have a table T204 and the AR SYSTEM automatically creates a view on top
> of it called "TEIS_SURVEY_TEXT"
>
> I need to create a view and need to know the ramifications of creating a
> view of a view.
>
> I could create my view like this:
>
> CREATE OR REPLACE VIEW "ARADMIN"."TYCO_ADR_SURVEY_TYPE_V" ("REQUEST_ID",
> "STATUS", "LANGUAGE") AS
> SELECT REQUEST_ID , STATUS, LANGUAGE FROM TEIS_SURVEY_TEXT;
>
> Which would be a view of a view.
>
> Or should I create it like this:
>
> CREATE OR REPLACE VIEW "ARADMIN"."TYCO_ADR_TEIS_TYPE_V" ("REQUEST_ID",
> "STATUS", "LANGUAGE") AS
> SELECT T204.C1,C8,C536870918
> FROM T204;
>
> What are everyone's thoughts?
>
> Lisa Kemes
> AR System Developer
> Tyco Electronics
> 717-810-2408 tel
> 717-602-9460 cell
> lisa.ke...@te.com
>
>
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11
> www.wwrug.com ARSList: "Where the Answers Are"
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
> This email is confidential and intended solely for the use of the
> individual(s) to whom it is addressed. The information contained in this
> message may be privileged and confidential and protected from disclosure.
>
> If you are not the author's intended recipient, be advised that you have
> received this email in error and that any use, dissemination, forwarding,
> printing, or copying of this email is strictly prohibited. If you have
> received this email in error please delete all copies, both electronic and
> printed, and contact the author immediately.
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
