On 05/12/2022 12:14, Bo Guo wrote:
Partitioning the table if possible should also help.
This really only helps if the partitioning is relevant to the query. Otherwise it can slow things down.
Eg, if you partition on date, and search on date, the partitioning will probably help, but if you partition on date, and search on name, it'll be no quicker, and will possibly be slower.
Paul -- Paul Smith Computer Services Tel: 01484 855800 Vat No: GB 685 6987 53 Sign up for news & updates at http://www.pscs.co.uk/go/subscribe
