October 13, 2003 at 1:20 pm
If a table has nonclustered indexes and if a view is created from this table will the indexes of the underlying table be used when retrieving values from this view. any help on this will be greatly appreciated.
TIA
October 13, 2003 at 3:58 pm
Yes, they can be used.
--Jonathan
--Jonathan
October 14, 2003 at 2:48 am
hi!
you want to know which indexes are used for your queries (regardless if "normal" selects or views): turn on "show execution plan" in query analyzer and examine the result.
best regards,
chris.
October 14, 2003 at 7:54 am
For a diagrammatical explanation of the execution plan, type ctl + K
Good luck.
October 14, 2003 at 8:01 am
Just to make sure does views use only clustered index or even non clustered index. is there any link which would give bit mroe deratil about it.
October 14, 2003 at 9:09 am
One more thing. Is it possible for the views to use the indexes if tables are on different database and views are on different database.
October 15, 2003 at 3:00 am
P.S You must be in QA and use CTRL+L or as Chris said, turn on the Showing of the Query Plan (not estimated which you will get with the shortcut)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply