Explain this better
Warning: This is a newbie question. :) I've read the sticky post, but I couldn't find an answer for my question.
I'm dealing with some huge databases - over 60 million records with a lot of text searches such as first letter of the first name, partial text search, etc.. The fields are all VARCHARs.
So I've created 3 full text indices.
firstname
lastname
firstname+lastname
Is that the best approach?
Another question would be why would someone not want to use a fulltext index on a varchar field if queries are being executed against that field?
Subject
Views
Written By
Posted
Explain this better
3519
March 28, 2011 01:27PM
1675
March 29, 2011 09:26PM
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.