2009 Feb 19 8:32 PM
How does a view accommodate indexes?
Are the indexes of its tables made part of the view?
And does a SELECT issued against the view trigger a
index?
2009 Feb 19 8:50 PM
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.
A view is just for convenience.
2009 Feb 19 8:43 PM
They are if you include them in the view.
Rob
