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"
