Gleened some information from your latest post on your new thread and combined it here. Don't know if it is going to help or not.

declare @Portfolio nvarchar(32)

declare @mtd2 float

DECLARE...

Just read Riya_Dave's latest post, just more of the same "I'll repost what I have already posted, maybe with a few minor but incomrehensible changes."

I wanted to say something, but...

Without more information there really isn't much we can do. The problem is that we can't see everything you see. We really...

Don't worry, I'm done....

riya_dave (4/19/2012)

---

Lynn, i have seen your post to every thread,instead of helping , you just posting your stranded one to everybody.

thats so annoying . and i dont except any response...

preetham gowda (4/19/2012)

---

Check the read and write %age on the tables. If the table is queried ones in a year, then there is no pointing in having indexes for such...

Not really, the code you posted is Oracle.

Plus, not enough information to give you an answer.

No you haven't. Nothing you have given is going to help us help yopu.

Please, tell me why you won't read that article and follow the instructions it provides?

You do know that all you are doing is fragmenting any responses you may get to solve your problem for one. Second, you still haven't figured out how to...

How about providing the code and execution plan (as a .sqlplan file).

GilaMonster (4/19/2012)

---

SQLKnowItAll (4/19/2012)

---

To add a bit that people often forget is the uniqueness of the column(s) indexed. If the data is skewed the index may not be very helpful unless...

The Dixie Flatline (4/19/2012)

---

I hope you were talking about...

You are only pulling the account column from #temp1,...

Your point? The only thing you are pulling from #temp1 is what appears to be an Account. Nothing else.

Go here: http://msdn.microsoft.com/en-us/library/ms188917(v=sql.100).aspx.