Click here to Skip to main content
14,538,686 members
   

Database

 
GeneralRe: Billion rows Pin
jschell6-Apr-18 10:03
Memberjschell6-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
Memberjschell14-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
Memberjschell17-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
Memberjschell24-Mar-18 6:18 
GeneralRe: Billion rows Pin
Jörgen Andersson24-Mar-18 8:18
professionalJörgen Andersson24-Mar-18 8:18 
B-tree is not hash based.

MySQL DOES support[^] hash-based indexing, but that is not supported on neither MyISAM nor InnoDb. Only for Memory storage engine and NDB-clusters.
And then you still need to choose between b-tree OR hash-based index.

Hash-based indexes are obviously NOT ordered.

I don't know anything about Amazons databases, so whether your index is hash-based or not is something you need to check.

In my very personal opinion, the only reason to use a hash-based index instead of b-tree is if your data doesn't have any kind of ordering to it, like GUIDs for example.

<edit>Curiosity took over, I wondered why your RefID was char(22), and it seems like a base64 encoding of GUIDs use exactly 22 characters.</edit>
Wrong is evil and must be defeated. - Jeff Ello


modified 24-Mar-18 14:44pm.

GeneralRe: Billion rows Pin
jschell31-Mar-18 6:56
Memberjschell31-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
MemberVK197-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
MemberVK199-Mar-18 7:43 
AnswerRe: Identity behavior in sql server 2008 and 2012 Pin
jschell10-Mar-18 10:30
Memberjschell10-Mar-18 10:30 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
VK1912-Mar-18 2:27
MemberVK1912-Mar-18 2:27 
GeneralRe: Identity behavior in sql server 2008 and 2012 Pin
jschell14-Mar-18 15:16
Memberjschell14-Mar-18 15:16 
Questionmerge to output matched and not matched Pin
indian14328-Feb-18 11:09
Memberindian14328-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
MemberMember 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
MemberSudhir Dehade27-Feb-18 1:19 
Rant[REPOST] Unable to find Postgresql data source in Entity Data Model Wizard Pin
Richard Deeming27-Feb-18 2:12
mveRichard Deeming27-Feb-18 2:12 

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.