shlogg · Early preview
Franck Pachot @franckpachot

Effective SQL Indexing Strategies For Optimized Query Performance

Improve SQL indexing with column order. Don't need best index, just effective one. Follow 'How to' guide for optimal results.

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