Ah - dang Stephen - don't B 2 cruel!
-K-
Sent from my iPhone
On Nov 12, 2016, at 1:30 PM, Stephen Russell srussell705@gmail.com wrote:
Hahahahaha.
On Sat, Nov 12, 2016 at 7:42 AM mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
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]