Click here to Skip to main content
14,841,092 members
Home / Discussions / Database
   

Database

 
QuestionDB2 to SQL conversion Pin
Member 1028121715-Mar-18 4:06
MemberMember 1028121715-Mar-18 4:06 
AnswerRe: DB2 to SQL conversion Pin
Victor Nijegorodov15-Mar-18 5:09
MemberVictor Nijegorodov15-Mar-18 5:09 
AnswerRe: DB2 to SQL conversion Pin
Richard Deeming15-Mar-18 6:41
mveRichard Deeming15-Mar-18 6:41 
QuestionBillion rows Pin
jschell10-Mar-18 10:39
Memberjschell10-Mar-18 10:39 
AnswerRe: Billion rows Pin
Jörgen Andersson10-Mar-18 11:42
professionalJörgen Andersson10-Mar-18 11:42 
GeneralRe: Billion rows Pin
jschell14-Mar-18 15:13
Memberjschell14-Mar-18 15:13 
GeneralRe: Billion rows Pin
Mycroft Holmes14-Mar-18 17:29
professionalMycroft Holmes14-Mar-18 17:29 
GeneralRe: Billion rows Pin
jschell17-Mar-18 5:58
Memberjschell17-Mar-18 5:58 
Ok.

Per the OP table looks like the following

Table T
     id char(22)
     RefId1 char(22)
     RefId2 char(22)


I need to do the following
1. Verify that RefId1 and RefId2 are in a different table either in that order (1,2) or (2,1)
2. Report if neither or only one id is found.
3. Report if more than one match is found
4. If found report if a different column (not documented above) is same as in the second table.

The second table also has a billion rows.
Both tables have indexes on the id, and the two other columns documented above.
GeneralRe: Billion rows Pin
Mycroft Holmes17-Mar-18 13:18
professionalMycroft Holmes17-Mar-18 13:18 
GeneralRe: Billion rows Pin
jschell24-Mar-18 6:14
Memberjschell24-Mar-18 6:14 
GeneralRe: Billion rows Pin
Mycroft Holmes24-Mar-18 13:08
professionalMycroft Holmes24-Mar-18 13:08 
GeneralRe: Billion rows Pin
jschell31-Mar-18 7:01
Memberjschell31-Mar-18 7:01 
GeneralRe: Billion rows Pin
Mycroft Holmes31-Mar-18 13:40
professionalMycroft Holmes31-Mar-18 13:40 
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
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 
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 

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.