Tag Info

New answers tagged

1

For some queries EXPLAIN tries to run some subqueries to get the stats - it is a known bug which is fixed in 5.6 and in MariaDB (10 at least, not sure about 5.5). Your indexes are not good enough - you have two single-column indexes on yearly_project_commits - but the query can use only one at a time. You should create one multicolumn index with both the ...


3

In this case, it's doing an Index Scan. As best as I know, the difference between an Index scan and a Bitmap Index/Heap Scan is that the former will read pages in the order defined by the index, while the latter will create a bitmap of pages to read (possibly from multiple indexes), order the results, and read them in [heap] order. Correct. There are ...



Top 50 recent answers are included