I have 2 equally structured databases under the same Sql2000 Server with exact table structures & stored procedures. The main difference is that 1st Db is at size of 2736MB & 2nd Db at size of 3471MB. A similiar stored procedure executed produces drastically different times. 1st DB at 30 secs, 2nd DB at 358s.. [This stored procedure packs a series of processes to insert new rows, does updates & deletes across about 5-8 tables..] I have done indexes for all the tables, though I might have overdone it. [May have more indexes than really needed.] Still the 1st Db can do it in 30s.. I have around 402383 entries for about 5 tables in the 1st Db.... and around 52,2142 entries for about 5 tables in the 2nd Db.... Not sure if I need to further optimize my transact-sqls, [have tried so already, but the diff in the runtime is unusually big, to cause concern and I was unable to figure out why... ], re-do my indexes, or break the 2nd DB up into distributed Dbs..[or all of these] Please advise.... Thanks. Am still limited in my tuning experience to transact-sqls & indexes..