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
Can we insert data into materialized view?
What is the difference between unique and primary key constraints?
What is cross join example?
How do I run a sql script?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
how to do backup entire database? : Transact sql
How do you update sql?
Why do we use triggers?
What is record variable?
what is the different between now() and current_date()? : Sql dba
Explain the uses of database trigger.
How many developers work on postgresql?
What do we need to check in database testing?
What trigger means?
What is number function in sql?
