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 types of joins are used in writing subqueries?
How to compare dates in oracle sql?
Give the different types of rollback segments.
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Is there an oracle sql query that aggregates multiple rows into one row?
What privilege is needed for a user to query tables in another schema?
How to use subqueries with the in operator using oracle?
What is the difference between I and G in Oracle?
What is an oracle user role?
What is data block in Oracle?
What is background process in Oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Differentiate between pre-select and pre-query?
How do I start tns listener?
How will you write a query to get a 5th rank student from a table student_report?