FROM A, B, C, D, E
WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND
A.ID = E.ID;
ID is primary key for table A and are foreign keys for
tables B, C, D, E. It is one to many relationship
Each table has around 500 records. I do a query like
above. It takes around 6 seconds. I try to create
index for ID in table B, C, D and E. But it not help.
Can someone show me anyway I can improve the speed for
this query. I have SQL Server 2000.
Thanks any help.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
