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...

If the problem exists still, better post the table details and query plan details. You will get good replies from this site.

Try to force index for the second statement which is written in UNION ALL.

Try it out and Let me know.

modify the statement as

(index = INDEX-2)

or... you can use force the index.

SELECT * FROM EMPLOYEEINFO_INDEX (index INDEX-2)

WHERE Department = 'ABC' OR Department = 'XYZ'

Check out the query plan and let me know.

Hello Guys,

We are facing some indexes related problem in SQL server 2000. The scenario is as follows...

We have a table EMPLOYEEINFO having...

http://www.sqlservercentral.com/articles/TSQL/62867/

Use Tally table to split the comma seperated values.

Create View v1

as

Select Eno,Ename from e1.dbo.emp

where Eno = 5

Union All

Select Eno,Ename from e1.dbo.empmast

where Eno = 5

Now,

Select Eno,Ename from v1

http://msdn.microsoft.com/en-us/library/aa197141(SQL.80).aspx

http://www.mssqlcity.com/Articles/Adm/attach_database.htm

visit the above URL.

d_sysuk (7/16/2008)

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

Okay so the posters had part I published several times, with various answers... using min/max, a subquery, a temp-table.

The perfm. analysis can be made easily by Sam/others just run...

Hi Chris and Jeff,

I am leaving for the day. Will continue tomorrow.Please post your replies.

I have executed all these three methods more than 10 times, But i got the same result at all time.

1) update #t1

set #t1.Name = T.Name

from T , #t1

where #t1.ID =T.ID

2)...