Re: String match is too slow in huge table
How long is your name and surname field?
The index gets very big if the length is long.
Maybe you can try to index only a prefix of the fields.
For example, index only the first 5 chars, or any number that makes sense to you.
create index namesur on sisben (name1(5),surname1(5));
Also, you can do an EXPLAIN to make sure the index is actually used.
Subject
Views
Written By
Posted
9132
December 23, 2004 11:37PM
Re: String match is too slow in huge table
3673
December 27, 2004 11:54PM
3333
December 28, 2004 12:38PM
3081
December 31, 2004 07:38PM
3305
January 03, 2005 02:54PM
2836
January 03, 2005 05:08PM
3071
January 04, 2005 06:57AM
2520
January 04, 2005 11:05AM
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.