On Tue, Aug 26, 2014 at 09:20:25AM +0200, Gert Burger
wrote:
> We have some queries which needs to find the oldest/latest rows which match
> certain conditions and having the id field as the last column in an index
> provides us with huge performance gains(Due to significantly less random
> reads
Hi
We have some queries which needs to find the oldest/latest rows which match
certain conditions and having the id field as the last column in an index
provides us with huge performance gains(Due to significantly less random
reads of old data).
Something like: 'SELECT id FROM table WHERE cond1 A
Hi!
On Mon, Aug 25, 2014 at 10:22:32AM +0200, Gert Burger
wrote:
> Is it possible to create indexes using SQLO that include the current
> 'Table's primary key?
> eg DatabaseIndex(col1, col2, col3, 'id')
>
> Currently SQLO is complaining that the column doesn't exist.
It seems you're right -
