Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bharath
explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
how can you implement fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the difference between clustered and non-clustered index? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
which background process invoke at the time of upgradation tell me???
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the steps you will take to improve performance of a poor performing query?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
