[AccessD] inner workings of operators

I just bought this book.

http://www.amazon.com/exec/obidos/ASIN/0596005733/qid=1097601592/sr=2-1/ref=
pd_ka_2_1/102-0324991-1214550

I have just started reading it but it is definitely educational.  Let me
know how much I don't know.  ;-)

It also has a good tutorial about indexes and how they actually work, btrees
and all that, plus what happens in an index when you insert, delete and
update the data (field) the index is on.

John W. Colby
The DIS Database Guy


-----Original Message-----
From: Porter, Mark [mailto:MPorter at acsalaska.com]
Sent: Monday, October 11, 2004 1:17 PM
To: Access Developers discussion and problem solving
Subject: RE: [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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com