in reply to Re: Re: Re: Heap sorting in perl
in thread Heap sorting in perl
If that particular column is not indexed, I suggest index it, as you need it.
If this is a write-mostly, query-infrequently table, indexing could significantly degrade performance. For log/audit files that record large numbers of miscellaneous value, indexing the values is rarely an effective strategy.
In Section
Seekers of Perl Wisdom