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
4 ай бұрын
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
4 ай бұрын
@@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🙂
@ryeaton
2 жыл бұрын
Computer science vids from you: interested.
@599CD
2 жыл бұрын
Kewl
@annagevorkian5615
2 жыл бұрын
Interested, can’t wait!!!
@599CD
2 жыл бұрын
For what?
@alializadeh8195
Жыл бұрын
Thanks
@599CD
Жыл бұрын
Welcome
@rabidfollower
2 жыл бұрын
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
2 жыл бұрын
Yeah, indexing is usually something I do well after the database is up and running.
@arodtv8582
2 жыл бұрын
Computer science! Put my mane on that list.
@599CD
2 жыл бұрын
Roger that
@CStrieker
2 жыл бұрын
What would happen if you changed the indexing of a field to No Duplicates, but there were already duplicates in the field?
@rabidfollower
2 жыл бұрын
It would say "can't create index, duplicates found" or something to that effect.
@599CD
2 жыл бұрын
What ^ he said.
@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?
@stephenbeswick2163
2 жыл бұрын
Yes please I would be very interested in learning about science yes please Richard?
@599CD
2 жыл бұрын
Sweeeeet
@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)
Пікірлер: 28