June 17, 2024, 1:12 p.m. | Franck Pachot

DEV Community dev.to

A new blog post with the theory and an example of the art of indexing: finding the best index for one query and also understanding that you don't need the best index:










Improving Your SQL Indexing: How to Effectively Order Columns | Yugabyte



Improve your SQL indexing by effectively ordering columns - follow the detailed instructions in this new ‘How to’ guide.




yugabyte.com


art blog database distributed example improving index indexing query sql theory understanding you yugabyte yugabytedb

AI Focused Biochemistry Postdoctoral Fellow

@ Lawrence Berkeley National Lab | Berkeley, CA

Senior Data Engineer

@ Displate | Warsaw

Staff Software Engineer (Data Platform)

@ Phaidra | Remote

Distributed Compute Engineer

@ Magic | San Francisco

Power Platform Developer/Consultant

@ Euromonitor | Bengaluru, Karnataka, India

Finance Project Senior Manager

@ QIMA | London, United Kingdom