Answer Posted / prabhudatta barick
Please ignore my first answer...
as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.
to get the exact record please use this
ANALYZE TABLE <table_name> COMPUTE STATISTICS;
SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why do we need view in sql?
What are triggers in sql?
What is sql dialect?
What is the importance of sqlcode and sqlerrm?
How many times can we commit in a loop?
How does postgresql compare to oracle/db2/ms sql server/informix?
Is inner join same as self join?
What are some emotional triggers?
What's the procedure?
What are procedures used for?
How do I debug a stored procedure?
What is the most important ddl statements in sql are?
What is difference between my sql and sql?
Why we use sql profiler?
How do I run pl sql in sql developer?
