INDEX
with several fields for table notes
.
Combines the two fields title, description
to create one indexCREATE TABLE note (
id int AUTO_INCREMENT,
note_id int,
title varchar(50),
description varchar(50),
PRIMARY KEY(id, note_id),
INDEX ind_title_description (title, description)
);
If we need to filter the result with both fields (title, description)
at the same time, then ind_title_description
is a great index