August 4, 2008 at 3:51 pm
Query returns with 1 minute but when I use insert command to insert into table . it is taking forever. There are only less then 1000 rows returning in the query.
Why it's taking forever inserting into a table when qeury returting within a minute.
any help will be appreciated
August 4, 2008 at 4:34 pm
I found another thing.
If I use following query it is taking forever.
insert into table name
SELECT DISTINCT field 1,field 2,field 3
FROM dbo.TBL_ANAL_CLMS_SMG
but when I remove DISTINCT from the command, it takes only few secounds.
really weird
August 5, 2008 at 1:28 pm
I created indexes on the tables and works fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply