Answer Posted / prabhudatta barick
Automatic Optimizer Statistics Collection
By default Oracle 10g automatically gathers optimizer
statistics using a scheduled job called GATHER_STATS_JOB.
As it gathers table statistics automatically
so no need to gather table statistics before
running this query.
SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';
This will give u the total no. of records in a table....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the sql versions?
What is cold data?
How do I run pl sql in sql developer?
What are the indexing methods?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between numeric and autonumber?
Is like operator in sql case sensitive?
Can we insert data into materialized view?
What are the types of keys?
How we can update the view?
Why is pl sql used?
Which command is used to delete a trigger?
What is the difference between syntax error and runtime error?
What is the use of triggers?
What is the difference between sum and count in sql?
