Answer Posted / kumar srinivasalu

BY USING HINTS,
HASH JOINS,
PARTITION TABLES AND INDEXS,
RESERVE KEY INDEX,
BIT MAP INDEX,
COST BASED OPTIMIZATION,
Nested loops,full table scans,query rewrite with
materialisation views
BASED ON THIS WE OPTIMIZE THE SQL QUERIES.

Can we insert data in view?

501

---

What is materialized view in sql?

461

---

How to know the last executed procedure?

586

---

How do you write an index?

524

---

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

499

---

---

what are the limitations of identity column? : Transact sql

604

---

How do I view a sql database?

555

---

Explain isolation levels. : Transact sql

575

---

How to rename a table?

556

---

Is pl sql better than sql?

548

---

What are system versioned tables?

549

---

What are the dml statements?

682

---

What are the ddl commands?

533

---

What is oracle and pl sql?

659

---

Describe types of sql statements?

543

---