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
23995
April 20, 2005 12:53PM
13340
April 21, 2005 07:39AM
10618
October 19, 2005 10:48AM
9549
October 20, 2005 09:28AM
6545
October 07, 2008 05:52PM
6750
October 28, 2008 01:46PM
9152
April 21, 2005 08:50AM
7643
May 06, 2005 09:52AM
6691
January 27, 2006 05:23PM
Re: Index views?
6491
January 31, 2006 09:07AM
9819
June 14, 2006 08:20AM
5789
June 21, 2006 11:32AM
6160
June 27, 2006 06:51AM
5275
April 01, 2009 07:29AM
6201
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.