[AccessD] inner workings of operators

In the vein of optimization of SQL, I got a wealth of very specific information from this book and it might be worth a look;

http://www.amazon.com/exec/obidos/tg/detail/-/159059164X/qid=1097514715/sr=8-4/ref=sr_8_xs_ap_i4_xgl14/102-7440773-1342551?v=glance&s=books&n=507846

And SQL performance does matter, even in today's systems.  Your low use database you create for 20 users today could become a component of a web enabled database with global availability tomorrow.

Mark

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of 
> Susan Harkins
> Sent: Sunday, October 10, 2004 11:06 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] inner workings of operators
> 
> 
> Knowing how it works behind the scenes can often help you write more
> efficient code. Also, can help you decide which choices will 
> perform better.
> With today's system, it hardly matters anymore unless you're 
> dealing with
> zads of records, but it's still the kind of stuff developers 
> want to know. 
> 
> Susan H.  
> 
> 
> 
> Hi John
> 
> > Me too
> 
> Ehh ... why?
> 
> /gustav
> 
> 
> > I'm looking for technical explanation of how In and Or work 
> behind the 
> > scenes -- don't need a tutorial on how to use either operator, just 
> > interested in how the engine interprets and uses them. If 
> anyone knows 
> > of such documentation, I'd be grateful for a link.
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

***********************************************************************************
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS