mark mcaulay wrote:
> 3. when viewing the design, it shows indexes as MUL for multiple, when there are
> indexes on only one column. It would be good to have the distinction between single and
> multiple column indexes. An example could be colour coding so you can see which index is
> on which columns.
That's not what MUL means. MUL means that the index is not unique --
i.e., you can have several rows with the same indexed column values.
For example, a primary key column (usually an ID) is unique. But if you
have a database of employees and you want to index them by first name,
you would not use a unique index on the "first_name" column.
--
Adam Hooper
adamh@stripped
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
