<html>
<!-- BEGIN WEBMAIL STATIONERY -->
<head></head>
<body>
<!-- WEBMAIL STATIONERY noneset -->
<DIV></DIV>
<P>Unique index means no duplicates. A regular index allows duplicates. I'm not sure I understand indexing, but I think it keeps a separate table with only that column(s) for faster lookups. It appear that you can also specify a column with unique values that is not indexed.</P>
<P> </P>
<P>Carl<BR></P>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">-------------- Original message from Barry Von Ahsen <barry@vonahsen.com>: -------------- <BR><BR><BR>> when I try to make a column unique then index it in phpMyAdmin, it does <BR>> it, but complains that you shouldn't use unique and index on the same <BR>> field. I've checked the mysql manual for indexes[1], and it doesn't say <BR>> anything good or bad (but it doesn't say much at all). <BR>> <BR>> is this bad/good/indifferent? does unique imply index? <BR>> <BR>> this is for mysql 4.1 <BR>> <BR>> -barry <BR>> <BR>> [1] http://dev.mysql.com/doc/refman/4.1/en/mysql-indexes.html <BR>> <BR>> _______________________________________________ <BR>> Cialug mailing list <BR>> Cialug@cialug.org <BR>> http://cialug.org/mailman/listinfo/cialug </BLOCKQUOTE>
<!-- END WEBMAIL STATIONERY -->
</body>
</html>