Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> View performance problem
I have a view created which joins 3 tables. A product table, a store
table and a sales transaction table.
Up until this past week, hen I queried the view, the performance wasn't
bad, however this week the performance is really slow. This is even
with no on else on the system.
No changes have been made to the view and no data was added to the 3
tables the view uses.
I have no idea what is going on. Any ideas of things to check?
We are running Oracle 8.0.5 on NT 4.
Terry
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 29 2000 - 10:25:01 CST