table size

Hi Oracle Netters

This may seem like a simple problem but I'm looking for a quick way to get the total number of rows in a table. Now I know select count(*) from foo; will work but that is a little compute intensive. Is there another less intensive way then a full table/index scan? It doesn't appear Oracle keeps the number laying around anywhere.

-- 
/-----------------------------mike_at_clinicom.com-------------------------------\


| Mike Bacovcin     |   The foundation of a good demo.. like true science     |

| 303/443-1726 x155 |                                                         |


| CliniCom, Boulder |        "...pay no attention to that                     |