how will u find statistics of a database objects?

Question Posted / pgnath

2 Answers
8490 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how will u find statistics of a database objects? ..

Answer / ramesh kotha

exex dbms_stats.gather_table_statistics
('<schema>','<tablename>');

Is This Answer Correct ?

1 Yes

0 No

how will u find statistics of a database objects? ..

Answer / senthil vinayagam

Using analyze command

Is This Answer Correct ?

2 Yes

2 No

Post New Answer

More SQL PLSQL Interview Questions

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

What does an inner join do?

0 Answers

what is csv? : Sql dba

0 Answers

What is sql procedures and functions?

0 Answers

What is the difference between sql and isql*plus?

0 Answers

Does sql backup shrink transaction log?

0 Answers

What is magic table?