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]
Tidak ada komentar:
Posting Komentar