I have 2 databases , let us say A & B. I run a Query with multiple innere joins . Database A contains 4 times records than database B.
My query takes 1 seconds to get executed in Database "A" and 5 minutes in Database "B".
The Database structure of A & B is same , In fact "B" has been created from Dump of "A". What could be the possible cause of such delay.