Hi,
A brief discretion for indexing.
What is indexing?
When should it be used?
Which fields must be indexed? primary key, foreign keys, regular fields...
Thanks
Hi,
A brief discretion for indexing.
What is indexing?
When should it be used?
Which fields must be indexed? primary key, foreign keys, regular fields...
Thanks
a field you would use to join in queires:
foreign keys , yes
Primary key: N/A, not needed since its a primary key and already indexed.
reg fields, no.
see this link about benefits of indexing
https://www.access-programmers.co.uk...rmance.291268/
to add to Ranmans comments I would also index fields regularly searched and/or sorted on