On 5 Apr 2011, at 6:54pm, Guilherme Batista wrote:
let's say I get the number of rows from the first table scan of the
execution. I would compare it with the number of rows defined for the table
in sqlite_stat1 (I ran the analyze once, and there are no index in my
tables). If the difference
On 5 Apr 2011, at 8:47pm, Guilherme Batista wrote:
Yes it's true.
But I'm not trying to improve the SQLite performance. I'm just studying the
query optimization of databases in general, and a better way to optimize if
the tables do not have indexes and if the query is complex and deals with
On 4/4/2011 2:05 AM, Guilherme Bamepe wrote:
Hi!
I'm new in SQLite, and I'm studying it to do a work in my college,
and would be helpful if I get the SQLite to print, while executing
the sql, after each table scan or join, the name of the table and
number of rows that are going to the next
On 4 Apr 2011, at 11:53am, thilo wrote:
On 4/4/2011 2:05 AM, Guilherme Bamepe wrote:
Hi!
I'm new in SQLite, and I'm studying it to do a work in my college,
and would be helpful if I get the SQLite to print, while executing
the sql, after each table scan or join, the name of the table and
Hi!
I'm new in SQLite, and I'm studying it to do a work in my college, and would be
helpful if I get the SQLite to print, while executing the sql, after each table
scan or join, the name of the table and number of rows that are going to the
next operator...
for example.. the following sql:
