I need help creating a composite index on MySQL plz Create a composite index on

Question

I need help creating a composite index on MySQL plz

Create a composite index on the attributes last_name and first_name (in that order!) of the Bird table.

Paste your CREATE INDEX statement below.

variety income Peacock bdate Owns first name Bird bname latitude longitude ast locati Cno senti ment Utter Chirp 1 (Original M (Chirper) N (Copy) Parrots About Bird level Listen name N (Listener M interests Topics bsecto date User Topics Listen Watcher Signup date password emai add State country For Bird, Watcher ISA User: picture street Bird AND Watcher COVER User number mailcode

Explanation / Answer

In mysql indexing we have BTRee so we drill down BTREE to find the values in select query.

Following is the query

ALTER TABLE Bird

ADD INDEX compound(last_name,first_name);

id: 1

select_type: SIMPLE

table: Bird

type: ref

possible_keys: compound

key: compound

key_len: 200 here this is length of both fields together

ref: const,const

rows: 1

Extra: Using where

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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