"Tim Jones" <TJones@xxxxxxxxx> writes: > Why is postgres using a sequential scan and not the index what > parameters do I need to adjust You probably initialized the AIX database in a non-C locale. See the manual concerning LIKE index optimizations. regards, tom lane
