On Sat, 21 Dec 2002 01:13:11 +0100 Kris Wolff <[EMAIL PROTECTED]> wrote:
> 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); The indexes in group one are single column indexes while the one in group two includes both columns in the table. None of them are unique indexes so they can't be used to enforce uniqueness, but they may improve fetching if their columns are used in a SELECT WHERE clause. What sort of differences are you looking for? -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
