Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Newbie stumped - Large SQL Select is SLOW. need Speed Please!
heya - ok i checked, i have indexes on the name fields of the 3 sib tables i also would like only the records from the left table, not some cross tabbed thingy. so not sure if inner join would help? it currently runs in 3 and 1/2 minutes. kinda slow still, are you guys sure you cant write... -
Newbie stumped - Large SQL Select is SLOW. need Speed Please!
ok i have a database, 4 tables. table 1 - "ATBAT" it contains 1,400,000 records table 2 - "RESULT" has 130 records table 3 - "PLAYER" has 2500 records table 4 - "TEAM" has 30 records so i do a SELECT on ATBAT and that gives me 1.4 mil records, too much and i go to GROUP BY RESULT, PLAYER and...
