Database Administrators Asked on October 28, 2021
I have a join that takes a lot of time:
select t1.*, t.b from t1 join (select id, b from t2) t on t1.id = t.id
I have an index on id
in t2
.
select t1.*, t.b from t1 join t2 t on t1.id = t.id
?
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP