Best way to index large text/varchar fields
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Best way to index large text/varchar fields
- From: "Chris Hoover" <revoohc@xxxxxxxxx>
- Date: Fri, 9 Jun 2006 11:45:23 -0400
In 8.1, what is the best way to index large text/varchar fields for wild card searches?
I am getting good number of queries being submitted for reporting purposes that are doing the following - where <text/varchar field> like '%some phrase%' and ....
Is there a good way to index these fields so that the db engine will use and index?
Thanks,
Chris
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]