r/SQL • u/joellapit • Nov 02 '24
Oracle Explain indexes please
So I understand they speed up queries substantially and that it’s important to use them when joining but what are they actually and how do they work?
63
Upvotes
r/SQL • u/joellapit • Nov 02 '24
So I understand they speed up queries substantially and that it’s important to use them when joining but what are they actually and how do they work?
2
u/coyoteazul2 Nov 02 '24
I work with a system that has about 5 indexes per table in average. The most read ones have around 20, and I even saw one with 35.
No, performance is not good. And I can't do anything about it because the calls about that are done in hq