Dear Friend..

Ok now u check the below attached the Excel sheet..

Dear Friend...

Please check attached the Excel...

thanx for the article...

Replay ASAP

Dear Friend...

Please check attached the Excel...

thanx for the article...

Dear Friend

check attached the execution plan here..

please replat ASAP

thanks

select ID,AuditMaster_ID,CallTo,CallTypeTag from auditdata

where AuditData.TATCallType = 'null' and Calltolen=12 and AuditData.CallTo like '91%'

put index on calltolen

now the above query taking 1.02 minutes

No trigger used in the Query

as u say i m, adding new column in the Table where i update the Callto len

and adding index to that column..

Dear Fried

without insert

this below SQL Query takes 59 secods with index on Tatcalltype column

select ID,AuditMaster_ID,CallTo,CallTypeTag into callto from auditdata

where AuditData.TATCallType = 'null' and len(AuditData.CallTo)=12 ...

ok

i will attach Execution Plan within 5 mintues..

ok..here i m attached the Execution plan JPG file for the below query.

insert into Auditdata_callto select ID,AuditMaster_ID,CallTo,CallTypeTag from auditdata

where AuditData.TATCallType = 'null' and len(AuditData.CallTo)=12 ...

ok i will attache the execution plan with a 5 minutes...

Dear Friends,

Thanks for your replay..

as u say if i m using function in where clause then no use of index

then now

i removeed index on the that both columns ...

Dear Friends,

Thanks for your replay..

i remove index on the that both columns...but now its take more that 10 minutes to run

Thanks ,

i will check and get back to u...

Hi,

Even when i execute below Simple Query its take more than 20 minutes

update Auditdata set tatcalltype = 'null' where tatcalltype is null

tatcalltype datatype is varchar

i put the...

Dear Friends

Thanks for your reply

if i run below query its take more than 35 minutes

insert into sms_tatcalltype Select distinct AuditData.ID,'12','1','null' from Auditdata...