While Indexes are our time saviours for read operations, as I said, it is expensive for insert, delete, and update operations.
1. Don’t use indexes for small tables
2. Cols with low selectivity, like if a col has true -> 99% and false -> 1% no use here
Covering Index -> basically, if you do the indexing on a particular column but you want other column values after filtering, you can use a covering index
Syntax: create index index_name on table_name(col_name) include (col_name2, col_name3);
Let's discuss indexes and query optimization today (Postgresql)!
What is an Index? -> An index is a data structure used to store data; it helps in searching or filtering the data rather than scanning the whole table
Syntax : create index index_name on table_name(col_name);
82 Followers 487 FollowingFull Stack Developer in making | Spring Boot + React
Job Portal Project • Building in public
#100DaysOfCode | Learning from mistakes
26 Followers 61 FollowingProfessionally debugging my code | Personally debugging my life | Figuring things out because Ctrl + Z doesn't work in real life—especially at 22 ;)
14 Followers 255 Following🚀 Passionate about harnessing the power of machine learning to tackle real-world challenges and create meaningful impact ...!
57 Followers 562 FollowingBTech-MTech CSE (Cybersecurity)@NFSU| Building Skills Across CS, AI, ML, Data Analysis & Security | Always Learning | Open to Tech Opportunities
112K Followers 751 FollowingRetired designer (AI took my job)
Now making art and studying human consciousness
— Previously @Lemonade_Inc
— Founder https://t.co/uImZ0zWUu5
4K Followers 444 Following20 • Builder • Geek • 3D Artist • building - https://t.co/6cLFJFNxWJ, https://t.co/SE7de9GHiC • built - https://t.co/QMipRGUYFo, https://t.co/sh80arLWLC & a lot more
83K Followers 99 FollowingHelping freshers land the right tech job with https://t.co/cCfEz36BnM 🚀 • @jobfound5 • https://t.co/LCoabXQSwa • https://t.co/xEyURDithZ