Re: Can't get my indexes right
Seems like the problem is the tinytext name field, and the UNIQUE (name(128))
Maybe it is better to use a VARCHAR(255) instead of TINYTEXT and UNIQUE(name) instead of using the prefix of 128. If you want only 128 chars, specify 128 in the varchar definition instead.
Subject
Views
Written By
Posted
3362
November 26, 2005 04:53PM
Re: Can't get my indexes right
2232
November 27, 2005 07:28PM
2078
November 28, 2005 02:44AM
2271
November 28, 2005 03:17AM
2022
November 28, 2005 07:40AM
2148
November 28, 2005 02:19PM
2134
December 21, 2005 10:34PM
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.