Re: Suggestion on index creation for TEXT data field

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 21, 2020 at 7:28 AM postgann2020 s <postgann2020@xxxxxxxxx> wrote:
which is having an avg width of 149bytes.

The average is meaningless if your maximum value exceeds a limit.

2. What type of index is the best suited for this type of data?.

And what type of data exactly are we talking about.  "TEXT" is not a useful answer.

If the raw data is too large no index is going to be "best" -  as the hint suggests you either need to drop the idea of indexing the column altogether or apply some function to the raw data and then index the result.

David J.


[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]

  Powered by Linux