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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you create a user-defined lock?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you find out if a table can be redefined?
how can you get actual data change values from previous transactions in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
when does an alert gets signaled?
What are the steps you will take to improve performance of a poor performing query?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is transparent data encryption? : sql server DBA
what are the differences of where and if in SAS?
what is a crs resource?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?