Yes sir, I know about " .explain ". Next time I would try that @ Richard
Hipp.
And thanks Clemens.
On Fri, Apr 10, 2015 at 3:57 PM, Clemens Ladisch wrote:
> Sairam Gaddam wrote:
> > On Thu, Apr 9, 2015 at 1:04 PM, Clemens Ladisch
> wrote:
> >> Sairam Gaddam wrote:
> >>> sql="create table em(nam
Then why there is a loop (Next opcode at 23rd instruction) over second
table when it created an index ?
On Thu, Apr 9, 2015 at 1:04 PM, Clemens Ladisch wrote:
> Sairam Gaddam wrote:
> > sql="create table em(name text primary key,age text,pts text);"\
> > "create table l(name text primary key
Sairam Gaddam wrote:
> On Thu, Apr 9, 2015 at 1:04 PM, Clemens Ladisch wrote:
>> Sairam Gaddam wrote:
>>> sql="create table em(name text primary key,age text,pts text);"\
>>> "create table l(name text primary key,fame text);";
>>>
>>> sql = "select * from em,l where l.fame=em.age";
>>>
>>>
On 4/9/15, Sairam Gaddam wrote:
>
> Below is a sample VDBE program:
>
>0 Init 0 270 00
>1 OpenRead 020 3 00
>2 OpenRead 1 150 2 00
>3 Rewind 0 250 00
>4 Once
//create table
sql="create table em(name text primary key,age text,pts text);"\
"create table l(name text primary key,fame text);";
//insert values
sql="insert into em values(44,20,1);"\
"insert into em values(11,20,2);"\
"insert into em values(5,21,3);"\
"insert into l values(11,11);"\
"i
Sairam Gaddam wrote:
> sql="create table em(name text primary key,age text,pts text);"\
> "create table l(name text primary key,fame text);";
>
> sql = "select * from em,l where l.fame=em.age";
>
>4 Once 0 130 00
>5 OpenAutoindex230 k(3,nil,ni
6 matches
Mail list logo