NYCPHP Meetup

NYPHP.org

[nycphp-talk] Re: newbie question/confusion

Brian O'Connor gatzby3jr at gmail.com
Wed Feb 23 09:25:06 EST 2005


About that ... when you create a unique field on a table, does that
automatically make that an index as well?


On Wed, 23 Feb 2005 09:20:12 -0500 (EST), David Mintz
<dmintz at davidmintz.org> wrote:
> 
> Just to add a little more onto the pile of more-answer-than-you-asked-for:
> it's probably wise to create some indexes on your tables to speed up
> SELECT operations. The columns frequently appearing in your WHERE clauses
> are good candidates.
> 
> There's http://www.databasejournal.com/features/mysql/article.php/1382791
> but I'm sure there's plenty of other fine reading material out there.
> 
> ---
> David Mintz
> http://davidmintz.org/
> _______________________________________________
> New York PHP Talk Mailing List
> AMP Technology
> Supporting Apache, MySQL and PHP
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.nyphp.org
> 


-- 
Brian O'Connor



More information about the talk mailing list