Hi Gail,

I have just now executed two queries ie from table1 and table2, Now i am having 15062 records in both the tables and table1 is taken 45 sec and table2 has taken 6 min and 35 sec.

and the i executed this query in master database

SELECT SD.NAME,SD.dbid,lastWaittype FROM SYSPROCESSES SP INNER JOIN

SYSDATABASES SD ON SD.DBID=SP.DBID WHERE SD.DBID=21

and what i got with table1 is nothing and with table2 is

DbName ID lastwaittype

DBNAME21 WRITELOG

i want to know what can we do to make this table2 fun faster as table1.

Thanks in advance.