Is there any other way to recover it?

Thanks for reply.....

I will work on the solutions you have given......

See attached queries & execution plans screenshots...

1.SELECT * FROM EMPLOYEEINFO_INDEX

WHERE DEPARTMENT ='TP'

OR DEPARTMENT = 'EAGLE'

2.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

union all

SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT = 'EAGLE'

3.SELECT...

hi karthikeyan,

see my previous post for attachement...

total rowcount without any conditions = 3215

total rowcount when Dept 'Abc' = 81

total rowcount when Dept 'XYZ' ...

See attached queries & execution plans screenshots...

1.SELECT * FROM EMPLOYEEINFO_INDEX

WHERE DEPARTMENT ='TP'

OR DEPARTMENT = 'EAGLE'

2.SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT ='TP'

union all

SELECT * FROM EMPLOYEEINFO_INDEX WHERE DEPARTMENT = 'EAGLE'

3.SELECT...

I have run following queries simultaneously in query analyser.

1. SELECT * FROM EMPLOYEEINFO

WHERE DEPARTMENT ='ABC'

OR DEPARTMENT = 'XYZ'

Query Cost : 15%

2. SELECT * FROM EMPLOYEEINFO (index = TEMP)

WHERE DEPARTMENT...

Hey..finally it works...

Query should be..

SELECT * FROM EMPLOYEEINFO_INDEX (index = INDEX-2)

WHERE DEPARTMENT ='ABC' OR DEPARTMENT = 'XYZ'.

But basic problem remain as it is. For above query query cost is 73%...

Hi karthikeyan ,

...

karthikeyan (7/31/2008)

Quick solution is, just use union all statement. check out the query plan now and let me know.

----------------------------------------------

SELECT * FROM EMPLOYEEINFO_INDEX

WHERE Department = 'ABC'

Union All

SELECT * FROM EMPLOYEEINFO_INDEX...

yaah...

We are going to create these table as per user_name who is active in session & drop that table as soon as it's job over.

thanks for support.

HELLO GUYS,

I have resolved this problem. Actually I was creating local temp table. The scope of any local temp table is into the block in which...

Jeff,

Thanks for u'r suggestion.

I will check it out.

John Rowan (6/18/2008)

---

And to expand on what Rudy has said, because the rows themselves are not affected until a modification takes place, this whole scenario changes if you add the...

rudy komacsar (6/18/2008)

---

To answer you question on where columns are added is a bit lengthy. To really oversimplify simplify things greatly a row on a page in SQL Sever...