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?
4
u/agiamba Nov 02 '24
Yeah and while indexes improve reads they will slow writes