The query below is very long, and it takes about 5 seconds to get the
result. Of course I am not happy with the 5 seconds, and I am wondering if I
can get a better speed if I can break it into several shorter queries. In
general, how do you do that? The following query contains only fake
contents(so that no policy will be violated), and it should show what's the
long query I am talking about.
Thank you, Siemel. Not sure why I can't reply to your reply to the "SQL
index problem" thread. I also tried to open the "Index with OR queries"
thread, but it said "Message is no longer available on the server".
SELECT TableA.id , TableA.score, Name, CName FROM TableB, TableA, TableC
WHERE TableA.DID=5153 AND TableA.id IN
(104606,159135,56115,159144,159176,10969,159153,15 9141,159133,101609,159141,
141411,159168,138575,155954,159175,159143,1655,159 167,159161,159166,159134,1
49541,159173,3890,135155,1,159174,159155,3413,5196 ,159156,190570,159151,1591
47,1115,43653,63875,165350,159169,159165,11011,965 1,43308,13904,159170,14986
8,93,111034,873,43647,155478,51116,159171,159148,4 711,71736,159137,80033,430
67,1110,493,3931,8736,159138,159171,9561,47831,159 177,43651,194688,1194,8868
3,116337,159158,43654,171813,159117,106853,165348, 159131,159178,111133,15916
0,159130,159140,159145,8171,159180,15174,159151,13 717,1079,159179,17,1900,15
9146,159118,159139,80036,159046,46166,104775,15911 5,159183,43711,106918,1591
61,86363,188159,159150,159131,159159,43657,159181, 159163,159149,5311,91317,8
1140,9746,80037,163163,90,19,159157,43655,159119,1 1111,91,159154,159181,1106
3,15175,91,159136,49095,10,159164) AND TableA.id = TableB.id AND TableA.CID
= TableC.CID GROUP BY TableA.id , TableA.score, Name,CName