This is probably a very simple query, but not sure of the best way to approach it. anyways instead of just asking for someone to DO it for me, here's my scenario.
I need to query datatables for two things
1) row count for total docs loaded
2) total number of doc names
Concern of course is for when there's tables that go above our 25,000,000 row limit, or whatever we have it setup in prod as.
I am thinking for this the arsseg table is a good way to start. I can query-
select a.name, b.table_name from arsag a, arsseg b where a.agid=b.agid
Why am I doing this?
Writing a little script so my ops team can see, "where an extraction process is at"
thanks in advance, as always I am open to any other approaches