i m attached the my table defined above...

Dear Friends,

I m attached the JPEG of my Execution plan plz tell me Whats the problem in that query

why its taken lot of time to update.

i optimize my SQL Query

select Distinct Auditdata.ID into Auditdata_sms FROM auditdata AuditData

INNER JOIN AuditMaster am ON am.ID = AuditData.AuditMaster_ID

iNNER JOIN...

here i m attached the table defination...

plz check & tell me is anything need to check.

revert me back ASAP

if i want to send you my table defination ..then how can i send that..because the database is large...

thanx for your help....

i will definately test what u said.....

but i heard that we should not use the indexes columns in where clause

when we update that particular table.

can i put the index on the columns whos data type is varchar...

hey thanx ..

let me check..

i stores tatcalltype is null

for testing i update dated 'null ' inseted of NULL

one question is

which one is faster?????????

select * into

or insert into

i thought

Select count(*) from auditdata where tatcalltype ='null'

is faster than

Select count(*) from auditdata where tatcalltype is null

thats why i updated 'null' inseted of NULL

what u think which one is...

but i m running this SQL query on 4 GB ram machine

select count(*) from AuditData

Output:14661374

select count(*) from AuditData where TATCallType = 'null'

Output:14661374

select count(*) from AuditData where Calltolen=12

Output:14569138

select count(*) from AuditData where CallTo like '91%'

output:14566305

i have index on

ID-clustered index...

can i add indexed to the columns whom datatype is Varchar????

Dear friends..

select ID,AuditMaster_ID,CallTo,CallTypeTag from auditdata

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

i running above query

in the table i have only two column index

1.ID--Clustered index (data type :...