Re: Default Indexes on TransferText Method?

"Greg Strong" <news.REMOVE@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:a1g0v3t7lbb95g9ul07ff5tm55nm4sdm0q@xxxxxxxxxx
On Sat, 29 Mar 2008 23:58:36 -0000, "Stuart McCall"
<smccall@xxxxxxxxxxxxxxx> wrote:

Go to Tools -> Options -> Tables/Queries and check out the option
'AutoIndex
on Import/Create'...

Thanks! The indexes are gone on the table auto build.

Somewhat related: I received complaints on the length of time the
queries ran at the end of the month. I always used indexes to speed
things up, however when I create them I use them. In this instance
numerous indexes were created on the source tables of the tables linked.

If numerous fields are indexed but not used in the source tables and
queries are ran from another mdb file does this create overhead and
slow down the queries?

TIA!

--
Regards,

Greg Strong

The only answer I can give is: probably. I don't know enough (ie hardly
anything) about JET internals to help with this. Perhaps someone else can
jump in?


.

Relevant Pages

  • Re: Default Indexes on TransferText Method?
    ... The indexes are gone on the table auto build. ... I received complaints on the length of time the ... queries ran at the end of the month. ... numerous indexes were created on the source tables of the tables linked. ...
    (comp.databases.ms-access)
  • Re: How To Avoid Cartesian Products?
    ... I will also be looking for ways to include the fire and auto queries you ... Create 2 queries (Fire and Auto) to give you a one-record monthly sum per ... Left Join those queries to your Agents table. ...
    (microsoft.public.access.queries)
  • dynamic numbering of results
    ... am trying to get an sql query that will auto number rankings for me. ... Through a number of queries I can load a temporay table with data e.g ...
    (microsoft.public.sqlserver.programming)