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