Re: [GENERAL] avoiding index on incremental column

2016-10-17 Thread Stephen Frost
* t.dalpo...@gmail.com (t.dalpo...@gmail.com) wrote: > I've a very huge table whose 1st column is a numeric value, starting > from 0 at the 1st row and incremented by 1 each new row I inserted. > No holes, no duplicates. > I need to perform some very fast query based on this value, mainly > around

[GENERAL] avoiding index on incremental column

2016-10-17 Thread t.dalpo...@gmail.com
Hi, I've a very huge table whose 1st column is a numeric value, starting from 0 at the 1st row and incremented by 1 each new row I inserted. No holes, no duplicates. I need to perform some very fast query based on this value, mainly around the last inserted rows. What is the best I can do? A