You might want to take a look at using a materialized view in Oracle 8i. I've never used them before myself but they build summary tables of data, basically caching. Dean jeff writes: > djc, > > :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > : From: Daniel J. Cody > : > : also , the front page query is taking like > : 20 seconds to run.. can we make a view out > : of this:? > :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > we can make a view out of it, but that won't give us any speed increases. a > view doesn't actually create another table of info to query, it just binds > together some sql logic into a resultset that can then be queried with > simpler queries. > > my suggestion would be to take that query and make a stored procedure out of > it. then we'll get the speed of advantage.