MySQL Forums
Forum List  »  Views

Re: Index views?
Posted by: Oleksandr Byelkin
Date: January 31, 2006 09:07AM

it means that view itself have no indices, but it does not mean that query with view can't use indices of underlying table in case of MERGER algorithm. Just use DESCRIBE/EXPLAIN SELECT which you want to run.

Mr. Oleksandr Byelkin
MySQL AB, Full-Time Developer
Lugansk, Ukraine

Options: ReplyQuote


Subject
Views
Written By
Posted
23734
April 20, 2005 12:53PM
13259
April 21, 2005 07:39AM
10548
October 19, 2005 10:48AM
9483
October 20, 2005 09:28AM
6485
October 07, 2008 05:52PM
6690
October 28, 2008 01:46PM
9078
April 21, 2005 08:50AM
7601
May 06, 2005 09:52AM
6609
January 27, 2006 05:23PM
Re: Index views?
6433
January 31, 2006 09:07AM
9760
June 14, 2006 08:20AM
5735
June 21, 2006 11:32AM
6093
June 27, 2006 06:51AM
5212
April 01, 2009 07:29AM
6161
June 30, 2005 01:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.