C cezalinho Registered User. Local time Today, 03:22 Joined Jan 23, 2006 Messages 10 May 15, 2006 #1 hi when creating indexes for databases what needs to be indexed? is there an article online that explains it??
hi when creating indexes for databases what needs to be indexed? is there an article online that explains it??
KeithG AWF VIP Local time Today, 05:22 Joined Mar 23, 2006 Messages 2,591 May 15, 2006 #2 Any field that is going to be searched or used in the WHERE Clause of a SQL statement and of course Primary Keys and Foreign Keys are fields to index.
Any field that is going to be searched or used in the WHERE Clause of a SQL statement and of course Primary Keys and Foreign Keys are fields to index.
C cezalinho Registered User. Local time Today, 03:22 Joined Jan 23, 2006 Messages 10 May 17, 2006 #3 thank you very much your replies are very helpfull
B Banana split with a cherry atop. Local time Today, 05:22 Joined Sep 1, 2005 Messages 6,279 May 17, 2006 #4 Pat Hartman said: Indexes are automatically created for primary and foreign keys. Click to expand... Is this still true if you have to manually fill in foreign keys (e.g. popup forms or something outside a subform)?
Pat Hartman said: Indexes are automatically created for primary and foreign keys. Click to expand... Is this still true if you have to manually fill in foreign keys (e.g. popup forms or something outside a subform)?
