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