Hi Energy

Thanks for the complement on my site (I'm working very hard to get it operational by the end of this month ;-)

Anyway, I think I have to disappoint you, Oracle does not store a subset or anything like that of tabledata.

So if you have to run a query for the top 10 patients you'll have to run it time and again. Because the data in your table could be changed from the last time your ran it, therefore the query has to ben run again!

Maybe you could consider a to create a SNAPSHOT view that refreshes say every morning, you can then query this snapshot instead of the underlying table, but then you must accept that the result from your "top 10 query" is only as accurate as the time of your last snapshot.

Hope this helps.

Remi