There is a table defined on database A and B. I am able to perform select queries on table created in database A but while execute it on database b, the same query is running for undefined time.
A explain on simple select * query is running until aborted but doesnt provide results. Is this a DBA activity that needs attention for such a scenario.
eg: Select * from A.employee (Runs in 2 seconds)
Explain Select * from B.employee (Runs for undefined time)