Re: [SQL] problem with slow select

2004-05-03 Thread francescosaf
thank you for answer and excuse me for later this is query plan: QUERY PLAN --- Nested Loop (co

Re: [SQL] problem with slow select

2004-04-26 Thread Rod Taylor
On Wed, 2004-04-21 at 11:00, francescosaf wrote: > hi > > I have two tables: Please send results of EXPLAIN ANALYZE for the query in question. Thanks ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[SQL] problem with slow select

2004-04-26 Thread francescosaf
hi I have two tables: table: idcode varchar(15) -->references (idcode) table latitude float longitude float time timestamp p_a char(1) barcode address idprog serial... -->primary key flag boolean table idfact numeric(7,0) --->references . idcode varchar(15) --->pr