Sabtu, 31 Maret 2012

Re: [MS_AccessPros] Indexing Fields

 

hi Hendra,

1. when a relationship has RI, Access automatically creates hidden index(es).  IMO, it is not advisable to create another one since it is redundant.  To see all Indexes, even Hidden ones, run my Analyzer and look at the reports

Crystal's Analyzer
http://www.accessmvp.com/strive4peace/Analyzer.htm

2. No

3. Allen Browne has great examples here:

http://allenbrowne.com/func-DAO.html

Warm Regards,
Crystal

Microsoft MVP, Access
remote training and programming

www.AccessMVP.com/strive4peace

www.YouTube.com/LearnAccessByCrystal
www.YouTube.com/LearnByCrystal

* (:  have an awesome day :) *

________________________________
From: "agesthahendra

Hi Everyone...
I have several questions about indexing...

* Is there any effects if we indexed manually the foreign key
  fields..?(the RI is implemented)... i just want to make sure the
  fields are indexed because i want to transfer the MDB to Mysql.

* Does Access create index to the field automaticly if we build join in
  query design (not in tables relationships window)..?
  (the tables are not joined in tables relationships window)

* To make the process faster, do we have to drop the index of an
  indexed field before we run Append / Delete query...?
  If so, how the syntax to drop and create index (create index with
  the type of index ... Duplicate OK or No Duplicate)

Any explanation would be appreciated..thank you

Regards
Hendra

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar