Answer / santosh

you can use dbms_stats package

Answer / guest

We can gather statistics on a table through>>

analyze table TABLE_NAME compute statistics , or

analyze table TABLE_NAME estimate statistics


Regards
Abhinav

Answer / balu

exec dbms_stats.gather_table_stats('ownername','tablename')

what is the role of dip user in our database?

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

Give two examples of referential integrity constraints.

2 Answers  

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---