Hello.
If you make composite index on all fields you'll be able
to use it in searchings only on left-most prefixes of the key.
You should make a separate index for each field if you
want to search on each field, however, many indexes will slow
down inserts to the table.
Andy Pieters wro
On Thu, Dec 01, 2005 at 05:33:01PM +0100, Andy Pieters wrote:
> Hi list
>
> I have a data set that is composed of many fields (30+). The final app will
> allow the users to search records on each field.
>
> What is the best thing to index in this situation? Make an index for *all*
> fields?
Y
Hi list
I have a data set that is composed of many fields (30+). The final app will
allow the users to search records on each field.
What is the best thing to index in this situation? Make an index for *all*
fields?
With kind regards
Andy
--
Now listening to Phase - Morning Light on amar