Should I create an Index for a large insert operation in mysql? -
lets have following table 8 billion columns: subject text, predicate text, object text , want create table count different text values this: create table nodes (id bigint unsigned primary key auto increment, val text, count bigint unsigned); insert nodes(val,count) select subject, count(*) count triples group subject would index on subject predicate , object increase or decrease speed of insertion? a general rule of thumb: indices typically decrease write speeds, while increasing read speeds.