What are the commands you'd issue to show the explain plan
for "select * from dual"?
No Answer is Posted For this Question
Be the First to Post Answer
What are statistics, under what circumstances they go out of date, how do you update them?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you switch from an init.ora file to a spfile?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
what is difference between user managed backup and rman backup?
What is replication? : sql server DBA
In oracle 10g export, import if we declare rows=y/n what would be the output?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What would you use to improve performance on an insert statement that places millions of rows into that table?
why Datapump is faster than traditional export and import
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
the process of adding a cpu in sql server is called..?
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)