Please ignore this post. I accidentally double posted here and on the
performance mailing list. I think this belongs on the performance list.
Sorry for the noise.
Jann
Am 23.08.10 06:05, schrieb Jann Röder:
> I have two tables:
> A: ItemID (PK), IsssueID (Indexed)
> B: ItemID (FK), IndexNumber :
I have two tables:
A: ItemID (PK), IsssueID (Indexed)
B: ItemID (FK), IndexNumber : PK(ItemID, IndexNumber)
Both tables have several million columns, but B has much more than A.
Now if I run
SELECT A.ItemID FROM A, B WHERE A.ItemID = B.itemID AND A.issueID =
The query takes extremely long (sev
