Pages tagged index:

How b-tree database indexes work and how to tell if they are efficient (100' level) |

A team member thought we should add an index on a 90 million row table to improve performance. The field on which he wanted to create this index had only four possible values. To which I replied that an index on a low cardinality field wasn't really going to help anything. My boss then asked me why wouldn't it help? I sputtered around for a response but ended up telling him that I'd get back to him with a reasonable explanation.
Imported from How b-tree database indexes work and how to tell if they are efficient
How to find un-indexed queries in MySQL, without using the log at Xaprb
Invest simple with Lazy Portfolios -
Lazy Portfolios are helping investors intelligently build simple, successful winning portfolios by themselves and you watch your nest egg grow
In praise of git’s index //
▍ ★∴    ....▍▍....█▍ ☆ ★∵ ..../    ◥█▅▅██▅▅██▅▅▅▅▅███◤    .◥███████████████◤  ~~~~◥█████████████◤~~~~ , instant online Paypal payment! TT Assuring good quality, Coupons and feebies! Don't miss out! Jordan,AF1,Nike , RunningShoes, Sneakers, Dunks $40 Brand Jeans: $ 38 Brand sunglasses, $18 Brand Caps/Hats: $ 18 Brand Belts: $ 28 UGG boots:$ 55 Free Shipping, Retail and wholesale! Payment options: Paypal , TT, Westunion
I still run into people lambasting git for the concept of the index from time to time. It seems strange and superfluous to users of other VCSs – like a speed bump that serves no purpose. Why not just commit the changes in the working copy? This perception is understandable; when I first heard of git, back as a Subversion user, I was one of these people. How times and minds change. Today, I use it and rely on it so much that I can’t imagine moving to any other VCS that doesn’t have this concept. (And none of the contemporary contenders do.) Because of this, I keep responding to such criticism, repeating myself. I figured I should put my explanation down somewhere where I can point people to.
A fast, fuzzy, full-text index using Redis | is entirely based on a data-structure server called Redis. Redis is one of several new key-value databases which break away from traditional relational data architecture. It is simple, flexible, and blazingly fast. So why not use the tools we have already?
redis.smembers("word:" + metaphone("python"))
Interesting post about being able to search data in redis using indexing and phonetic algorthms.