Computer Science, asked by Anonymous, 11 months ago

Which column should be preferred while making indexing in MySQL ?

Answers

Answered by Anonymous

HERE IS YOUR ANSWER MATE:-

primary keys coloumn are typically great for indexing because they are unique and are often used to lookup rows. in general primary keys make good indexes.they are unique and must have a value specified.

HOPE THIS HELPS U DEAR MATE!!

PLS MARK ME AS BRAINLIST.

Answered by guptapragati492

Answer:

$\huge \boxed{ANSWER\::}$

$<body bgcolor="pink">$

Index key columns. It is desirable that the query returns the result fast, so make sure to index the columns which are used in JOIN clauses. In case you use UPDATE statement involving more than one table, make sure to index all the columns which are used to join the tables.

$<front size="4"> <marquee>✨I hope it will help u✨</marquee> $

Previous Question

Next Question

Which column should be preferred while making indexing in MySQL ?​

Answers

Which column should be preferred while making indexing in MySQL ?