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