MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: User-friendly approaches to displaying subtable data
Posted by: Rick James
Date: July 23, 2013 09:33PM

If that sample query were a VIEW, you would ignore it, and do
SELECT state FROM us WHERE city = 'Austin';
It would run faster if you had
INDEX(city)
but it would still work if you did not have such an index.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.