thanks for the info on the datestamps.

But query is taking lot of time to run , can it be tuned to run more faster.The query is

select s.domainid,d.domain,s.urlid,u.url,s.applicationargumentid,a.application_argument

from stats s,idomain...

thanks for immediate reply.I got it just now

Thanks a lot !!