Counting all rows in a table

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Counting all rows in a table

Message

From

27/06/2003 08:54:36

Gilles Perreault
Rivière Du Loup, Quebec, Canada

26/06/2003 15:13:37

Mark Moore
Cheektowaga, New York, United States

General information

Forum:

Oracle

Category:

Other

Title:

Re: Counting all rows in a table

Miscellaneous

Thread ID:

00804364

Message ID:

00804632

Views:

A select count(1) that is slow can also indicate a fragmented table... Like many, I often had a select count(1) that returned 0 after several minutes....

A reorg of your table 'may' be required.

Map

View

Click here to load this message in the networking platform