Answer Posted / ramesh kotha

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

What is the difference between partition and index?

979

---

what is the syntax used for partition in tsql? : Transact sql

1011

---

Write a query to find the names of users that begin with "um" in sql?

986

---

Enlist the advantages of sql.

999

---

Will truncate release space?

940

---

Why are indexes and views important to an organization?

945

---

how can we find the number of rows in a table using mysql? : Sql dba

1078

---

Enlist the data types that can be used in pl/sql?

1060

---

How do I view a sql trace file?

1019

---

How to rename a column in the output of sql query?

1070

---

Enlist the characteristics of pl/sql?

1791

---

Does inner join remove duplicates?

934

---

How to fix oracle error ora-00942: table or view does not exist

1008

---

How is debugging done?

966

---

What do you mean by table in sql?

986

---