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"
