Guys the whole problem was DISTINCT ...removed it an d performance increased like anything 🙂

But to be on the safe side ,I want some alternative to DISTINCT please suggest

GilaMonster (9/28/2012)

---

shield (9/28/2012)

---

GilaMonster (9/28/2012)

---

I would recommend to start get rid of the distinct unless it really is necessary. Distinct usually indicates poor design or incorrect queries.

Change the view to use...

laurie-789651 (9/28/2012)

---

Here's how to make the LEFT OUTER JOIN on E.

You should not put join conditions in the where clause - it's very old fashioned, & it's easier to read...

GilaMonster (9/28/2012)

---

I would recommend to start get rid of the distinct unless it really is necessary. Distinct usually indicates poor design or incorrect queries.

Change the view to use JOINs rather...