Database Views

[Former Member]

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?

[Former Member]

They are if you include them in the view.

Rob

[Former Member]

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.