All a function on what columns of data are included in an index. No if you have PKeys that are incremental INTs. That is FINE.
Yes if you have an index on a heavy INSERTed table, Customer, and LastName is indexed because the index will have to break pages to add new data. Not sure if you can set the open space of an index in Marina for character type columns. You don't want to tighten the free space in those index pages real tight because you will get a lot of new pages as more data comes in. When you have inserts down the road you may have more time keeping your indexes correct and you say that your system is slow. Hint Hint here. Numerous character indexes that are rarely used will slow down high speed inserts all the time. Using a table for Names and placing that KEY into the Customer table is superior to freely typing the last name "Williams" in that LastName column. On Wed, Nov 9, 2016 at 2:20 PM, Mike Copeland <m...@ggisoft.com> wrote: > Richard Kaye wrote: > >> Checking the health of indexes and refreshing statistics in an MS-SQL >> environment is a best practice. >> >> https://ola.hallengren.com/ >> >> -- >> >> rk >> > > Anyone have input on whether "checking the health of indexes...." is > necessary or recommended in a MariaDB environment? > > Mike Copeland > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyl8fadrpc+aqd63vknyxw1fmvrdkl7_a8-_vbkpkby...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
