Re: Preformance in multiple join
Posted by: Rasmus Toftegaard
Date: January 17, 2007 05:56AM

Hi and Thanks

I am testing the query now. Explain Select for my query give this:
1,PRIMARY,D,range,date,date,3,\N,111272,Using where; Using temporary; Using filesort
1,PRIMARY,<derived2>,ALL,\N,\N,\N,\N,113,
1,PRIMARY,<derived3>,ALL,\N,\N,\N,\N,106,
1,PRIMARY,<derived4>,ALL,\N,\N,\N,\N,35,
1,PRIMARY,<derived5>,ALL,\N,\N,\N,\N,61,
5,DERIVED,P,ALL,\N,\N,\N,\N,671,Using where
4,DERIVED,P,ALL,\N,\N,\N,\N,671,Using where
3,DERIVED,P,ALL,\N,\N,\N,\N,671,Using where
2,DERIVED,P,ALL,\N,\N,\N,\N,671,Using where

Options: ReplyQuote


Subject
Written By
Posted
Re: Preformance in multiple join
January 17, 2007 05:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.