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 packages are available to pl/sql developers?
What is the mutating table and constraining table?
how many triggers are allowed in mysql table? : Sql dba
How do I truncate a sql log file?
how to include comments in sql statements? : Sql dba
Does sql profiler affect performance?
how to use in conditions? : Sql dba
What is the usage of nvl function?
Explain what is dbms?
What is a clob in sql?
Which software is used for pl sql programming?
What is the process of debugging?
How to use transactions efficiently : transact sql
What is sql analyzer?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
