Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Question: Do views use indexes?

2 views
Skip to first unread message

sean

unread,
Nov 14, 2001, 3:07:03 PM11/14/01
to
Hi,


Just a quick question that I figured someone would know off the top of
the head:

Do views use the indexes on the tables they query? If I do a search
on a view joining two tables and look for information from the column
with a clustered index, does Sybase use the clustered index or do a
table scan?

Many thanks
Sean

0 new messages