How can you gather statistics on a table?
Answers were Sorted based on User's Feedback
Answer / mkjmkumar
A. If u want to gather statistics with output use
Set Autotrace on
B. IF u want to gather statistics only Without Output user
Set Autotrace TraceOnly
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kd
exec dbms_stats.gather_table_stat (owner, tablename);
or
analyze table xxx estimate statiistics;
Is This Answer Correct ? | 0 Yes | 0 No |
what is correlated subquery
the user should know to which database he is connected currently in oracle
Olap tools
How do you switch from an init.ora file to a spfile?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is the difference between the SQL*Loader and IMPORT utilities?
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What is Restricted Mode of Instance Startup in Oracle?
pl help me, i want oracle HRMS training institute address,in chennai
What is the disk migration? what is the steps involved in oracle disk migration?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable