what is analyze command ? what kind of statistics does it
generate?
Answers were Sorted based on User's Feedback
Answer / mr. chandra
analyze command is used to check the statics of the query
and performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brahma prakash
It Analyze the cost of the query with shortest excution path
| Is This Answer Correct ? | 0 Yes | 0 No |
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What is the difference between online and offline backups?
what is the difference between data migration and production migration.
What is a Synonym ?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
Explain oracle’s system global area (sga).
What are the limitations of check constraint?
How to do a full database export?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How would you extract DDL of a table without using a GUI tool?
what is load balancing and what u have used to do this?(sql loader)
What is the simplest tool to run commands on oracle servers?