having said that i have just run the code below in teh query plan and the second query is much more costly

select *

from Sales S inner join Customers C

...

ahh i understand now

so if i do a join in a query then it wont neccessarily create a cartesian join, it will look at the options and perhaps use a...

well for instance i have a booking table and a attendant table

there is a bookingid in the booking table and a bookingid in the attendant table

i know it is a...

well flippin ek

i have been messing with loop join and hash join options and these are making massive differences to my queries

smaller tables (in terms of numbers of rows) loop...

the output would be the same using sql or plsql

Stewart "Arturius" Campbell (8/15/2012)

---

erics44 (8/15/2012)

---

Yeah ive thought about that

what i...

Yeah ive thought about that

what i have proposed is that...

Thats a cracking idea thanks

why didnt i think of that 🙂

thats a pity

thanks for the replies

bump

Thanks a lot

spot on

Jeffrey Williams 3188 (7/15/2012)

---

I use CTE's to organize my queries and move derived tables up to the top of the query. In other cases, I will use a CTE...

i was chucked in the deap end much like you seem to have been and it worked for me, i picked the basics of TSQL quite quick

still learning lots and...

yep, its a good plan

im gonna have to work on my acting skills

🙂

i have a battle plan

i have editted 4 reports over the last couple of days that he had written queries for, replacing the queries with those for a newer schema...