CREATE TABLE foo ( url TEXT NOT NULL, INDEX(url(100)) );This says to index the first 100 characters of the `url` field. It is a way around the restriction of now big an index can be. But it often leads to an index that is never used.
|Indexes on Text Fields||1937||Valentine Andreev||11/28/2010 05:49AM|
|Re: Indexes on Text Fields||1035||Rick James||11/29/2010 09:20AM|
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.