What Is a Query Planner?
&gt; Anyone that has worked with large databases can testify how slow queries can get. This is often due to the necessary indexes not being there, or something in the query that stops the database system from using the index. Choosing the right indexes to use, and the right order to fetch data in, proves to be the difference between a 10ms and 5s query.<p>This seems incredibly intuitive. Anyone reading it would get the impression that query speed is very important for database users and that they would be eager to investigate any new technology that promised a substantial improvement in query performance.<p>Yet, I have found the opposite. I created a new kind of database that shows incredible performance gains when compared with mainstream databases like SQLite (<a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=Va5ZqfwQXWI">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=Va5ZqfwQXWI</a>) for simple and complex queries against tables of all sizes. It is able to do this without needing to create separate indexes on all the columns in the WHERE clause. The software is in open beta and available for free download at (<a href="https:&#x2F;&#x2F;www.Didgets.com" rel="nofollow">https:&#x2F;&#x2F;www.Didgets.com</a>) but it is like pulling teeth to get people to try it out.<p>If I post something like this on HN, I usually get lots of comments about how my claims are impossible (or at least improbable) but few are willing to actually test it themselves on their own machine with their own data set. I have several videos that demonstrate how quick and easy it is to load and analyze data, but interest has been minimal so far.<p>I feel like the inventor of a new kind of car engine that claims to get 2x the MPG while delivering the same horsepower, but can&#x27;t get anyone to take the free test drive and prove me right (or wrong).