how will u find statistics of a database objects?
- 2 Answers
- 7780 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / senthil vinayagam
Using analyze command
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is union?
Why is there a need for sqlcode and sqlerrm variables?
Can we write ddl statements in functions?
What is the main reason behind using an index?
what is a unique key ? : Sql dba
How can the performance of a trigger be improved?
how can we destroy the cookie? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Why use subqueries instead of joins?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is sqlite format?
Explain spool.
What is the default isolation level in sql server? : Transact sql
What are the built in functions of sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
