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 derfloh 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!
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...
