Answer Posted / gurudatt
better way is to use the sys.indexes table where it gives the total no rows for each table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is null value in oracle?
Explain rename?
Give the constructs of a package, function or a procedure.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the difference between replace() and translate() functions in oracle?
What are the database administrators utilities available?
What are the limitations oracle database 10g xe?
Why do we use coalesce function in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to use null as conditions in oracle?
How to export data to a csv file?
What are the uses of a database trigger?
What are the most common interview questions on ETL Testing for experience?
What to do if the startbd.bat failed to start the xe instance?