Re: Table Partitioning and Indexes Performance Questions

Would eliminating triggers and stored procedure would be step #1 to start seeing gains from partitions? We have many triigers and stored procedure and i am trying to to kake sure if need to deprecate before moving to partitioning. Many thx Andy Get Outlook for Android

Re: Planning time is time-consuming

Also, if you write sql with bind params, planning time should be once for the sql. Subsequent sql will use cached stmt. Get Outlook for Android From: Laurenz Albe Sent: Sunday, September 10, 2023 6:15:43 PM To: Mikhail Balayan ;