RE: [AccessDevelopers] Datawarehouse and linked local tables

Can you share the SQL of the pass-through as well as provide which fields are indexed?

Duane Hookom MVP
MS Access

________________________________
> To: AccessDevelopers@yahoogroups.com
> From: luvmymelody@yahoo.com
> Date: Wed, 4 Sep 2013 16:23:33 -0700
> Subject: Re: [AccessDevelopers] Datawarehouse and linked local tables
>
>
>
> Duane
>
> I indexed and created the pass through query but the pass through times
> out on me
>
> Jim Wagner
> ________________________________
>
> ________________________________
> From: Duane Hookom <duanehookom@hotmail.com>
> To: access developers <accessdevelopers@yahoogroups.com>
> Sent: Wednesday, September 4, 2013 1:09 PM
> Subject: RE: [AccessDevelopers] Datawarehouse and linked local tables
>
> Jim,
> This makes sense to me. If you are querying a table or data only in the
> warehouse, Access will optimize the request for data. If there is a
> join being performed on the Access side with a local table, it is much
> more complex since each record in the local table has to be matched
> with records in the warehouse.
>
> In addition to indexing, I would consider using a pass-through query to
> limit the records from the warehouse to a subset.
>
> Duane Hookom MVP
> MS Access
>
>
> ________________________________
>> From: hal_mcgee@beaerospace.com<mailto:hal_mcgee@beaerospace.com>
>>
>> Be sure and index the local table. I've had this issue before and
>> indexing the local table helps a lot.
>>
>> Good luck
>>
>>
> [mailto:AccessDevelopers@yahoogroups.com<mailto:AccessDevelopers@yahoogroups.com>]
> On Behalf Of luvmymelody@yahoo.com<mailto:luvmymelody@yahoo.com>
>>
>> Hello all,
>>
>> We have a data warehouse table in a query with a local table named
>> ACCOUNT joined together on the ACCOUNT field to act as a filter for the
>> query.
>>
>> The data warehouse table is huge and the query is now not working. We
>> took the local ACCOUNT table out of the query grid and added to the
>> criteria line LIke PL* and Like JC2* and the query runs in less than 10
>> seconds.
>>
>> This makes no sense because with the * we are asking for more accounts
>> than what is in the table and it runs faster. The query has run for
>> years so the ACCOUNT table has worked for a long time. Is there a
>> limitation to a linked local table or something?
>>
>> Thank You
>>
>> Jim Wagner
>
> ------------------------------------
>
>
> Please zip all files prior to uploading to Files section.Yahoo! Groups Links
>
>
> AccessDevelopers-digest@yahoogroups.com<mailto:AccessDevelopers-digest@yahoogroups.com>
>
> AccessDevelopers-fullfeatured@yahoogroups.com<mailto:AccessDevelopers-fullfeatured@yahoogroups.com>
>
> AccessDevelopers-unsubscribe@yahoogroups.com<mailto:AccessDevelopers-unsubscribe@yahoogroups.com>
>
>
>
>
>

------------------------------------


Please zip all files prior to uploading to Files section.Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessDevelopers/join
(Yahoo! ID required)

<*> To change settings via email:
AccessDevelopers-digest@yahoogroups.com
AccessDevelopers-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/