Index question

[Kris Wolff]

Hi,

A plain database question. Can someone explain the differeences between 2
Index types on a table like this:
Name VARCHAR(50), description LONGTEXT

1.Indextype
CREATE INDEX indexname_1 ON table (Name);
CREATE INDEX indexname_1 ON table (description);

And 2. Indextype
CREATE INDEX indexname_1 ON table (Name, description);


Thanks a lot for any comment.
Kris