ACCESS FEED: Re: [AccessDevelopers] Datawarehouse and linked local tables

Rabu, 04 September 2013

Re: [AccessDevelopers] Datawarehouse and linked local tables

Hal

I indexed the local table and it returned results but it is still spinning for the last 30 minutes

Jim Wagner

From: Hal McGee <hal_mcgee@beaerospace.com>
To: "AccessDevelopers@yahoogroups.com" <AccessDevelopers@yahoogroups.com>
Sent: Wednesday, September 4, 2013 12:20 PM
Subject: RE: [AccessDevelopers] Datawarehouse and linked local tables

Be sure and index the local table. I've had this issue before and indexing the local table helps a lot.

Good luck

From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of luvmymelody@yahoo.com
Sent: Wednesday, September 04, 2013 2:17 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Datawarehouse and linked local tables

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

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (4)

Recent Activity: