topic Database Views in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228349#M1208689 <HTML><HEAD></HEAD><BODY><P>How does a view accommodate indexes?</P><P></P><P>Are the indexes of its tables made part of the view?</P><P>And does a SELECT issued against the view trigger a </P><P>index?</P></BODY></HTML> Thu, 19 Feb 2009 20:32:17 GMT Former Member 2009-02-19T20:32:17Z Database Views https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228349#M1208689 <HTML><HEAD></HEAD><BODY><P>How does a view accommodate indexes?</P><P></P><P>Are the indexes of its tables made part of the view?</P><P>And does a SELECT issued against the view trigger a </P><P>index?</P></BODY></HTML> Thu, 19 Feb 2009 20:32:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228349#M1208689 Former Member 2009-02-19T20:32:17Z Re: Database Views https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228350#M1208690 <HTML><HEAD></HEAD><BODY><P>They are if you include them in the view.</P><P></P><P>Rob</P></BODY></HTML> Thu, 19 Feb 2009 20:43:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228350#M1208690 Former Member 2009-02-19T20:43:31Z Re: Database Views https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228351#M1208691 <HTML><HEAD></HEAD><BODY><P>A view contains no indexes but uses the indexes of the underlying tables if it can, just as SQL against the underlying tables use an index if it can.</P><P></P><P>A view is just for convenience.</P></BODY></HTML> Thu, 19 Feb 2009 20:50:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-views/m-p/5228351#M1208691 Former Member 2009-02-19T20:50:02Z