Hi, you should try to create index first. create index on points(lg,la);
Regards, litailang 2012年4月8日5:23 Patrice <[email protected]>: > My table is Points(id,Lg,La) with 50000 rows > I do this SQL request > > CREATE TABLE correspondances AS > SELECT reference.id1, toreplace.id > FROM (SELECT MIN(id) AS id1, lg, la FROM points GROUP BY lg, La) AS > reference > INNER JOIN points AS toreplace > ON reference.lg=toreplace.lg AND reference.la=toreplace.la; > > The delay of this request is more than 13 minutes. > > It's normal ? > > My browser is Chrome and I use H2 console. > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
