Re: Chained Rows
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: k3nnyp@xxxxxxxxx
- Date: Thu, 24 Apr 2014 02:02:48 +0400
On Thu, Apr 24, 2014 at 12:56 AM, Kenny Payton <k3nnyp@xxxxxxxxx> wrote:
>
> I know a lot of the tricks for avoiding chained rows and migrated rows but
> the only trick I know of to element these intra or inter block chained rows
> is to break the table into multiple tables or the row into multiple rows.
Sometimes might be helpful to redefine table with moving less-used columns
to the ends of rows. It allows to reduce extra-work if most queries use
only the first columns
--
Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org
Other related posts:
