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:[email protected]] On Behalf Of Kemes, Lisa Sent: Monday, January 24, 2011 2:07 PM To: [email protected] Subject: Re: View of a View? So is it recommended? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Monday, January 24, 2011 5:05 PM To: [email protected] 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:[email protected]] On Behalf Of Kemes, Lisa Sent: Monday, January 24, 2011 3:50 PM To: [email protected] 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 [email protected] _______________________________________________________________________________ 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"
