Thanks, much, it is exactly like what I wrote too.

It looks like we don't need the cursor. Not sure why PLSQL uses that.

mister.magoo (4/26/2013)

---

Not an answer about linked servers, more about triggers...

Please don't use a trigger for this, make all your transactions through stored procedures and have that update the Oracle server,...

Thanks, it seems I can only leave it as it is as a index scan for the view, and optimize other parts.

Thanks, tried to add filter with where studentID=.. and schoolyear=.. this time it uses the index seek.

The reason I asked this is because we have a view that is in...

Thank you, that is good to know too.

Right now this server is setup to use windows authentication, that works for us.

here are the table definition in attachment, and select. with a filter

No matter what I use the execution plan uses index scan.

Thanks, I would like to figure out this before I do the repair.

Thanks, that is a good alternative. I ended up adding that account temporily into database as dbowner when backing it up, after done, I removed it from original database.

So when...

Can this account itself add himself as a dbowner right after the database is restored?

Jeff Moden (4/16/2013)

---

...but we have a batch process at night that uses it [font="Arial Black"][highlight=""]for each [/highlight][/font]individual. so overall it...

rals (4/17/2013)

---

Batch process means SSIS package ?

If you are using SSIS, recently I came across a situation that extracting data using a view from SSIS slower but running the same...

GilaMonster (4/16/2013)

---

sqlfriends (4/16/2013)

---

I have a view, if we runs it individually in SSMS, it runs ok, but we have a batch process at night that uses it for each individual....

Thanks, that is very strange then,

In maintenance plan, we just use regular backup. we don't do with norecovery.

And I did check with one developer, he didn't do anything either.

Wierd...

By your hints, I do have some clue now.

we do have a full, diff, and a transaction log backup scheduled. Full happens only at weekend, transaction and diff will happen...

It is not using index for the view.

It is developed by other developers that has gone.

It does have underlying tables for the view, so I guess one purpose for using...