I have tables which have more than 100 million rows.
what is fastest way to get count of number of rows, count(*)
is putting too much load on the machine and it is taking lot
I did not analyze these tables, so I can't use num_rows in all_tables.
Any ideas ??