Re: Single large join vs. multiple queries
Date: 23 Feb 2005 18:27:19 -0800
First of all, I have never seen a 15 table join in a well-designed
database. This is suspect.
Next, if you want a result set that meets a certain criteria, then you
should do it as one statement, so that you don't have to save
intermediate results, so the optimizer can get everything it needs,
etc.
Relevant Pages
- RE: Expert design help - for NOOB - Long winded
... In case the link doesn't work, I googled "Database Desing for mere Mortals", ... "There would be no need to enter the suspect data, ... saved locally to the Investigator's respective suspect investigative folder" ... Then an encounter table with information on the encounter. ...
(microsoft.public.access.tablesdbdesign) - Re: improving performance by indexing query criteria fields
... establish relationships first in the relationships window. ... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...
(microsoft.public.access.setupconfig) - Re: improving performance by indexing query criteria fields
... establish relationships first in the relationships window. ... My advice is to index fields that you use to specify criteria and sort orders. ... important in a multi-user database, where the back-end is on a file server. ... appropriate records (assuming the query optimizer can use the index). ...
(microsoft.public.access.queries) - Re: Find largest alphanumeric value matching alpha criteria in dat
... the "Calif Insert" is a changing criteria that I need to be ... able to input in a cell. ... then go to the database to find all the records that also contain that same ... refers to the database and to a cell on the template: ...
(microsoft.public.excel.worksheet.functions) - Re: Access unter Citrix - Probleme beim Komprimieren
... Hat mir doch keine Ruhe gelassen, war ja auch nicht in MSDN oder KB, sondern in der TechNet drin: Microsoft Jet Database Engine Programmer's Guide, Chapter 4. ... The optimizer in the Jet database engine is a cost-based optimizer, which means the optimizer assigns a cost to each task and then chooses the least expensive list of tasks to perform that will generate the desired result set. ... The algorithms that the optimizer uses depend on the accuracy of the statistics provided by the underlying engine. ... Each time you prepare a request for information, either by sending an SQL statement as an argument to the OpenRecordset method of a Database object or by saving a QueryDef object in your database, Microsoft Jet runs through a complex series of analysis and optimization steps. ...
(microsoft.public.de.access) |
|
