I have many indexes and so far, it doesn't seem to be any downside to it.
----- Original Message ----- From: "mbsoftwaresoluti...@mbsoftwaresolutions.com" <mbsoftwaresoluti...@mbsoftwaresolutions.com> To: ProFox Email List <profox@leafe.com> Sent: Saturday, November 12, 2016 8:42 AM Subject: Re: Do you rebuild your indexes every night or do you leave them alone. On 2016-11-10 13:33, Stephen Russell wrote: > 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. I've inherited a system (RIP, Jeff) where some tables HAS AN INDEX ON EVERY (or nearly every) FIELD. Holy freakin' moly. [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/567377934.2313079.1479449709...@mail.yahoo.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.
