[sqlite] SQLite's use of memory only temporary data

On 4 May 2016, at 9:32pm, Nikolaos Tsikoudis wrote: > I execute a query and I see that SQLite creates temporary data that are > never written to the disk and I am trying to understand what happens. Use the EXPLAIN QUERY PLAN command: It will show you how SQLi

[sqlite] SQLite's use of memory only temporary data

You are right, I don't know why I didn't think to use explain query plan command earlier. Its output shows exactly what is going on. An automatic covering index is created. Thank you very much. On Wed, May 4, 2016 at 5:11 PM, Simon Slavin wrote: > > On 4 May 2016, at 9:32pm, Nikolaos Tsikoudis

[sqlite] SQLite's use of memory only temporary data

Hi, I execute a query and I see that SQLite creates temporary data that are never written to the disk and I am trying to understand what happens. My query's structure looks like the following: select sum() from table1 t1 table2 t2 where ( t1.a = t2.a and ... ) or ( t1.a = t2.a