how will u find statistics of a database objects?
Answers were Sorted based on User's Feedback
Answer / ramesh kotha
exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');
| Is This Answer Correct ? | 1 Yes | 0 No |
What is autocommit sql?
What is before and after trigger?
can sql servers linked to other servers like oracle? : Sql dba
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
What are different types of joins ?
What is a native sql query?
can i create trigger on synonym is it possible or not please help me
Can we insert in view in sql?
How will you a activate/deactivate integrity constraints?
what is innodb? : Sql dba
What are predefined functions in sql?
what does myisamchk do? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)