Click here to Skip to main content
15,900,258 members
Home / Discussions / C#
   

C#

 
GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude9-Feb-10 9:45
TheJudeDude9-Feb-10 9:45 
GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude9-Feb-10 10:02
TheJudeDude9-Feb-10 10:02 
GeneralRe: SQL select on two tables takes too long Pin
kevinnicol9-Feb-10 10:12
kevinnicol9-Feb-10 10:12 
GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude9-Feb-10 10:54
TheJudeDude9-Feb-10 10:54 
GeneralRe: SQL select on two tables takes too long Pin
kevinnicol10-Feb-10 2:05
kevinnicol10-Feb-10 2:05 
GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude9-Feb-10 11:38
TheJudeDude9-Feb-10 11:38 
GeneralRe: SQL select on two tables takes too long Pin
Mycroft Holmes9-Feb-10 18:10
professionalMycroft Holmes9-Feb-10 18:10 
GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude10-Feb-10 9:58
TheJudeDude10-Feb-10 9:58 
Sorry for th late reply. I received more documentation on the keys and indexes today. Here are the keys and indexes for the NINVREC table:
Table Indexes
Name Number of Fields
Key 1 2
Fields:
INV-MK-MODEL-NBR Ascending
INV-MK-SERIAL-NBR Ascending
Key 2 1
Fields:
INV-SERIAL-NBR-KEY Ascending
Key 3 1
Fields:
INV-PRIMARY-SERIAL-NBR Ascending
Key 4 1
Fields:
INV-DATE-SOLD Ascending
Key 5 1
Fields:
INV-LOCATION-REC-1 Ascending
Key 6 1
Fields:
INV-TICKET-NBR Ascending


Here are the keys and indexes for the MISCITEM table:
Table Indexes
Name Number of Fields
Key 1 6
Fields:
MISCITEM-DATE Ascending
MISCITEM-HOUR Ascending
MISCITEM-MINUTE Ascending
MISCITEM-SECOND Ascending
MISCITEM-DUPLICATE-TIME Ascending
MISCITEM-STORE-KEY Ascending
Key 2 1
Fields:
MISCITEM-SALE-DATE Ascending
Key 3 3
Fields:
MISCITEM-CUST-ACCT-NBR Ascending
MISCITEM-TICKET-NBR Ascending
MISCITEM-TICKET-SEQ-NBR Ascending
Key 4 2
Fields:
MISCITEM-MODEL-NBR Ascending
MISCITEM-SERIAL-NBR Ascending
Key 5 2
Fields:
MISCITEM-EXCHANGE-MODEL-NBR Ascending
MISCITEM-EXCHANGE-SERIAL-NBR Ascending
Key 6 1
Fields:
MISCITEM-PENDING-SALE-DATE Ascending


So if I do a join on the INV-MK-MODEL-NBR-INV-MK-SERIAL-NBR and MISCITEM-MODEL-NBR-MISCITEM-SERIAL-NBR that should speed it up, correct?
Jude

GeneralRe: SQL select on two tables takes too long Pin
TheJudeDude10-Feb-10 10:42
TheJudeDude10-Feb-10 10:42 
QuestionC# Pin
jojoba20109-Feb-10 5:09
jojoba20109-Feb-10 5:09 
AnswerRe: C# Pin
Not Active9-Feb-10 5:48
mentorNot Active9-Feb-10 5:48 
QuestionRe: C# Pin
jojoba20109-Feb-10 5:50
jojoba20109-Feb-10 5:50 
AnswerRe: C# Pin
Richard MacCutchan9-Feb-10 6:21
mveRichard MacCutchan9-Feb-10 6:21 
QuestionRe: C# Pin
jojoba20109-Feb-10 6:24
jojoba20109-Feb-10 6:24 
AnswerRe: C# Pin
Richard MacCutchan9-Feb-10 7:54
mveRichard MacCutchan9-Feb-10 7:54 
AnswerRe: C# Pin
hammerstein059-Feb-10 6:24
hammerstein059-Feb-10 6:24 
QuestionRe: C# Pin
jojoba20109-Feb-10 6:32
jojoba20109-Feb-10 6:32 
AnswerRe: C# Pin
#realJSOP9-Feb-10 7:56
professional#realJSOP9-Feb-10 7:56 
AnswerRe: C# Pin
Dave Kreskowiak9-Feb-10 6:13
mveDave Kreskowiak9-Feb-10 6:13 
QuestionRe: C# Pin
jojoba20109-Feb-10 6:18
jojoba20109-Feb-10 6:18 
AnswerRe: C# Pin
Dave Kreskowiak9-Feb-10 8:37
mveDave Kreskowiak9-Feb-10 8:37 
QuestionRe: C# Pin
jojoba20109-Feb-10 17:30
jojoba20109-Feb-10 17:30 
AnswerRe: C# Pin
Dave Kreskowiak10-Feb-10 2:00
mveDave Kreskowiak10-Feb-10 2:00 
AnswerRe: C# Pin
ThatsAlok9-Feb-10 20:03
ThatsAlok9-Feb-10 20:03 
QuestionApplication Compatibility and Startup Questions Pin
BlitzPackage9-Feb-10 4:55
BlitzPackage9-Feb-10 4:55 

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.