i need help with indexing on MYSQL plz nothing else create indexes (which are B+

Question

i need help with indexing on MYSQL plz nothing else

create indexes (which are B+ trees, under the hood of MySQL) on the Bird.first_name

attribute and Bird.birthdate attribute separately - i.e., create two indexes, one per attribute.

Paste your CREATE INDEX statements below.

Cno number btag string id number aid number caption string picture string wtag string Bird btag string gender string first name string last name string birthdate date income string Bird Listen tag string btag string Chirp btag String Cno number date date location latitude numbe location longitude numbe parrots btag string parrots cno number sentiment number text string Interest tag string id number level number Peacock ptag string variety string Topic d number name string description string Topic Listen tag string id number Use tag string email string password string signup date date address number string address street string address city string address state string address country string an arm arm am am an be be be CO CO dfo df

Explanation / Answer

As per the syntax,

The create index statements for the above requirements is

CREATE INDEX bird_birthdate_index ON Bird(birthdate) USING BTREE;

CREATE INDEX bird_firstname_index ON Bird(first_name) USING BTREE;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.