Indexing Fields in Microsoft Access Tables for Optimal Database Performance

[@tigranhayrapetyan8357]

Thank you, Richard! I've maken some columns in my databases for multi-table search form and it becomes extremly fast! 1 second instead of 15-30. The tutorial was very helpful, thank you again 😊

[@599CD]

You're welcome. Indexing def speeds things up! Just remember not to OVERUSE them. Too many indexes in a table can slow down updates, additions, and deletions because those indexes have to be updated. It's a balance.

[@tigranhayrapetyan8357]

@@599CD yeah, thank you for the comment. In my case I need only search in tables, not to add or update something. Thank you again for your awesome work on this channel🙂

[@CStrieker]

What would happen if you changed the indexing of a field to No Duplicates, but there were already duplicates in the field?

[@rabidfollower]

It would say "can't create index, duplicates found" or something to that effect.

[@599CD]

What ^ he said.

[@annagevorkian5615]

Interested, can’t wait!!!

[@599CD]

For what?

[@rabidfollower]

My experience is that indexing has become less and less crucial when PCs have become faster and faster. Nowadays when a query is slow, I suspect poor query design or table design before I look into poor indexing. I mainly rely on automatically-created indices such as the ones for primary fields. And I can't remember the last time I had to manually create an index myself.

[@599CD]

Yeah, indexing is usually something I do well after the database is up and running.

[@ryeaton]

Computer science vids from you: interested.

[@599CD]

Kewl

[@froggert119]

"You cannot index any of the field types that you shouldn't be using anyways: OLE Object, Calculated, Attachment." could you explain how one is supposed to deposit a pile of photos that will automatically adjust to the size of the report without creating duplicates?

[@chess86362]

how does duplicate(not ok) helps reduce I/O cost. isn't it making a index for a single data? or it is just used during data entry to have no duplicate values? if this is the case then how is this index(not ok) helping to reduce searching time(i/o cost)?? ALSO using duplicate ok in auto number? n is duplicate ok working as primary key??(same as above qstn)

[@599CD]

599cd.com/ask

[@alializadeh8195]

Thanks

[@599CD]

Welcome

[@arodtv8582]

Computer science! Put my mane on that list.

[@599CD]

Roger that

[@nathanwillett6918]

youre referring to REI arent you

[@599CD]

What's that?

[@stephenbeswick2163]

Yes please I would be very interested in learning about science yes please Richard?

[@599CD]

Sweeeeet

[@cruzinsweetsntreats]

Optimus Prime indexing.... 🤔🤫😁

[@599CD]

Megatron deleting...

[@cruzinsweetsntreats]

@@599CD exactly 💯👍

[@colinhursell9176]

I would be interested in computer.science videos.

[@599CD]

Awesome