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 is trigger in pl sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Write a sql query to find the names of employees that begin with ‘a’?
How do I know if I have sql express or standard?
What is a primary key called that is made up of more than one field?
What is java sql package?
Why is a trigger used?
How do I start sql profiler?
What is the clause we need to add in function body to return variable?
Explain aggregate functions are available there in sql?
How is data stored on a disk?
Explain mutating table error.
What is crud diagram?
Which normal form is best?
What is mutating trigger?
