Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: Billion rows Pin
Jörgen Andersson31-Mar-18 23:13
professionalJörgen Andersson31-Mar-18 23:13 
GeneralRe: Billion rows Pin
jschell6-Apr-18 10:03
jschell6-Apr-18 10:03 
AnswerRe: Billion rows Pin
Jörgen Andersson11-Mar-18 22:56
professionalJörgen Andersson11-Mar-18 22:56 
GeneralRe: Billion rows Pin
jschell14-Mar-18 15:15
jschell14-Mar-18 15:15 
GeneralRe: Billion rows Pin
Jörgen Andersson14-Mar-18 22:17
professionalJörgen Andersson14-Mar-18 22:17 
GeneralRe: Billion rows Pin
jschell17-Mar-18 5:52
jschell17-Mar-18 5:52 
GeneralRe: Billion rows Pin
Jörgen Andersson17-Mar-18 7:39
professionalJörgen Andersson17-Mar-18 7:39 
GeneralRe: Billion rows Pin
jschell24-Mar-18 6:18
jschell24-Mar-18 6:18 
I do not believe that is how that works.

The primary key is indexed. However indexing is a btree and based on a hash. I presume natural ordering on the index would be to walk the btree. But, again, that would be based on the hash.

In contrast "id > previous" is based on the value.

I do not have access to the hashing algorithm and even if I used "hash(id) > hash(previous)" then it would end up doing a table scan (or at least an index scan) which would not help at all.
GeneralRe: Billion rows Pin
Jörgen Andersson24-Mar-18 8:18
professionalJörgen Andersson24-Mar-18 8:18 
GeneralRe: Billion rows Pin
jschell31-Mar-18 6:56
jschell31-Mar-18 6:56 
GeneralRe: Billion rows Pin
Jörgen Andersson31-Mar-18 23:25
professionalJörgen Andersson31-Mar-18 23:25 
QuestionIdentity behavior in sql server 2008 and 2012 Pin
VK197-Mar-18 10:02
VK197-Mar-18 10:02 
SuggestionRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 8:04
mveCHill608-Mar-18 8:04 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
Richard Deeming8-Mar-18 9:14
mveRichard Deeming8-Mar-18 9:14 
PraiseRe: Identity behavior in sql server 2008 and 2012 Pin
CHill608-Mar-18 9:37
mveCHill608-Mar-18 9:37 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK199-Mar-18 7:43
VK199-Mar-18 7:43 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
jschell10-Mar-18 10:30
jschell10-Mar-18 10:30 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK1912-Mar-18 2:27
VK1912-Mar-18 2:27 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
jschell14-Mar-18 15:16
jschell14-Mar-18 15:16 
Questionmerge to output matched and not matched Pin
indian14328-Feb-18 11:09
indian14328-Feb-18 11:09 
AnswerRe: merge to output matched and not matched Pin
Jörgen Andersson7-Mar-18 11:07
professionalJörgen Andersson7-Mar-18 11:07 
Questionsql query to get code with max rank Pin
Member 927852427-Feb-18 6:55
Member 927852427-Feb-18 6:55 
AnswerRe: sql query to get code with max rank Pin
Richard Deeming27-Feb-18 7:58
mveRichard Deeming27-Feb-18 7:58 
AnswerRe: sql query to get code with max rank Pin
Paket Wisata Lombok28-Feb-18 6:01
professionalPaket Wisata Lombok28-Feb-18 6:01 
QuestionUnable to find Postgresql data source in Entity Data Model Wizard Pin
Sudhir Dehade27-Feb-18 1:19
Sudhir Dehade27-Feb-18 1:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.