…improve documentation), but finally I ended up with next load statement: /usr…BY DestCityName ORDER BY 2 DESC LIMIT 10; Years, InfoBright, MonetDB 1y, …2006 | 7141922 | | 2007 | 7455458 | | 2008 | 7009728 | +——+———+ And execution time: MonetDB: 6.3s and InfoBright: 0.31s To group all results…
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… sets [2]. Consider this “age = 18 and available = ‘divorced’”. I’ve used Russia as target for investigation and here is results: both… those columns, it’s up to you decide what to do. 1. http://www.mysqlperformanceblog.com/2006/08/10/using-union-to-implement-loose-index-scan-to-mysql/#comment-1695 2. http://dev.mysql.com…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
… in Early 2006 (while still …and cleaning up such very …only when discards results: CREATE TABLE `trunc` ( `…1421638051 | 3 | | 985505567 | 3 | | 1046160975 | 2 | | 141017389 | 2 | | 848130626 | 2 | | 888665819 | 2 | | 1001437915 | 2 | | 118824892 | 2 | | 2104712727 | 2 | +————+——-+ 10 …
