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
3391
November 26, 2005 04:53PM
Re: Can't get my indexes right
2246
November 27, 2005 07:28PM
2089
November 28, 2005 02:44AM
2288
November 28, 2005 03:17AM
2037
November 28, 2005 07:40AM
2164
November 28, 2005 02:19PM
2152
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.