2008/8/25 Scott Thornton <[EMAIL PROTECTED]>: > > Hi, > > Lots of things can go into the join clause....... and placing more criteria > into the join clauses can often speed-up your queries (especially for large > data sets) where the initial number of records can be reduced significantly. > > That said however, the query optimizer is the ultimate decider and it just > may place the criteria into the where clause. (I am referring to query plans > ). > > I guess its just what you are used to.... my background is in database > development, application development came a bit later.... >
That makes sense, I guess - about reducing the initial number of queries grabbed, I mean. Not sure about the query plans bit, though. My background is the exact opposite of yours. I learned DB stuff through needing it for application development. And since the DB subject at uni was pretty much a joke, there's a lot of little tricks and suchlike that I just never learned. Getting better slowly, though. :) Thanks, Seona. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
