Interested to Buy Any Domain ? << Click Here >> for more details...
How can you gather statistics on a table?
- 3 Answers
- 8906 Views
- I also Faced
- E-Mail Answers
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 |
Explain the use of table functions.
which one is currently in used software cmpanies.
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
Explain the difference between a data block, an extent and a segment.
the user should know to which database he is connected currently in oracle
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Give the reasoning behind using an index.
i have marks in table,how to find total?
3. Steps in UAT?
What are different types of transactions in ar? : oracle accounts receivable
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
Oracle General 
