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
How to Declare Fixed Length String Value In PL SQL
What is a pl/sql block?
What is difference between table and view?
What does an inner join do?
what is the use of set statement in tsql? : Transact sql
Can we use commit inside a trigger?
What is a ddl command?
What is the limitation on the block size of pl/sql?
What are the different ddl commands in sql?
What do you mean by query optimization?
What is count * in sql?
What is database sql?
How many triggers can be applied to a table?
What is a trigger in sql?
What is the difference between a procedure and a function?
