Thanks venku009 for the information. I will try it.

LqT 

Hi,

A mistake of my part. Sorry for that.

set statistics io on

set statistics time on

SELECT count(*)

FROM   address addr

WHERE  not exists ( SELECT 'x' FROM...

Hy guys,

First at all, the table address is not big table ( 20821 rows ). The only two tables bigger than address is runactv (1293406 rows) and tripacc (837146...