[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