Interested to Buy Any Domain ? << Click Here >> for more details...
When will you chose to run RUNSTATS?
- 1 Answers
- 9322 Views
- I also Faced
- E-Mail Answers
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
| Is This Answer Correct ? | 4 Yes | 4 No |
What does it mean if the null indicator has -1, 0, -2?
What are the full forms of spufi and dclgen and why are they used?
Define check constraint.
Where do you specify them?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
what is the maximum number of tables that can be joined ?
How to view db2 table structure?
What happens to the PLAN if index used by it is dropped?
what is parm utility
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
COBOL 
