150 word gist pros and cons of database index
Pros: It speeds up select querying by limiting what the database has to look through quickly. Its like a index in a book
to easily find what subject or idea you need to find. If a book has a 1000 pages and you need to find a certain word of phrase,
an index would be appropriate to to list everywhere that phrase is used.
Cons: Indexs take up space, and alot of it. Using the example above, if you had 10 indexs incuded in your book, you would then
have 1010 pages worth of data. It can cost alot of data storage to have indexs on many things on a table. It also takes more time
to create, update, and destroy from those tables that have indexs cause now each index has to be updated as well, which would take