Interested to Buy Any Domain ? << Click Here >> for more details...
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 different types of sql commands?
What are different types of queries in sql?
Can a commit statement be executed as part of a trigger?
Is not null in sql?
What do we need to check in database testing?
What is latest version of sql?
Why is sharding used?
What is the difference between explicit and implicit cursors in oracle?
What is the use of %rowtype?
explain the delete statements in sql
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Does truncate release storage space?
Where is all the data on the internet stored?
What is sql in java?
What are the different sql commands?
