That was my point, your query is basically asking just that.

SQ.SLid=" & slid & " AND DEkeyValue =" & slid

is the same as

A = C and B = C, hence...

Does this return anything??

SELECT SQ.*, DEdescription, DEenteredDate

, sendto.AOcontactNameLast AS SendTo

, billto.AOcontactNameLast AS BillTo

, req.AOcontactNameLast AS Requestor

, DE.*

FROM schoolrequest SQ

INNER JOIN academicoffice ST ON SQ.SLsendToId=sendto.AOid

...

This is just how the view wizard optimizes the where conditions. As wrong as it seems, it's often better for performance to have the query written that way. ...

Hmm, then I think that they either have to wait for the most current data or just accept the 5-10 minutes delay... I don't know any workaround in this situation.

If you are using 50 views to make this, I would strongly suggest you try to use only the base tables as you might see a big improvement from that....

Now I need to be shot... forgot that you couldn't access the server .

I think the faster solution might be to reinstall after all....

Maybe it's just me, but I don't see a single subquery in there. Also I would definitly run the index tuning wizard just to make sure you're not missing...

The idea of that design is to able to go to the last person who touched the record... not to be able to see the whole thing version by version....

Is it possible that you didn't reboot since the 120 days limit of a trial version?? IIRC, the evaluation check is done at startup, so unless you reboot, you...

That's not even a best pratice, that's just basic database design.

It's like if you have a db with cars and their owners over time.

You'd have a table car, a table...

Still can't answer that one. The other option you have is to split the select completely like this :

Create a stored proc on Oracle with the PrevYear, nextyear......

I'm not that rude, am I??

I can't think of a query that would absolutely require the use of 50 subqueries... I'd like to see one though .

You design is flawed. The type colum should be placed into its own table like so :

Table orderTypes

orderid, step, Type (all this being your clustered primary key)).

Then do...

Don't discount Joe's comment so easyly, he's 1000000000 % right about this. This is presentation work, and such work should be handled at the client side of the application....