Trying to index..

[malikah]

Hi, I'm trying to set an index on 3 of my columns but get this error:

 

#1170 - BLOB/TEXT column 'requirements' used in key specification without a key length

 

The last column in the table is TEXT TYPE containing some large paragraphs. I'm pretty new to all this. Do I need to index all columns? Do I even need an index? How does it improve my database?

 

Thank you.

[PC Nerd]

um, um not sure, but you cant index text types i think

 

also, only index a few fields, often the primary key is bext, and thats all i use

 

it speeds up searching, becauase it orders records by those index, and therefore search can go directly to the criteria, not search the entire database

[rcorlew]

I only index my id field which is set to int anyway. Makes for quicker queries I think since it is always unique.

[malikah]

um, um not sure, but you cant index text types i think

 

also, only index a few fields, often the primary key is bext, and thats all i use

 

it speeds up searching, becauase it orders records by those index, and therefore search can go directly to the criteria, not search the entire database

 

Hmm.. But what if I was doing this:

 

"SELECT abc, def, ghi FROM table1, table2...."

 

In other words, I'm selecting columns from the middle of the table that aren't primary or indexed?

[PC Nerd]

doesnt matter

 

if you go

 

SELECT fields FROM table WHERE contition = true

 

then it will still work..

its just indexing can make it slightly faster, but if its not a high load site, then i wouldnt worry too much

 

[malikah]

doesnt matter

 

if you go

 

SELECT fields FROM table WHERE contition = true

 

then it will still work..

its just indexing can make it slightly faster, but if its not a high load site, then i wouldnt worry too much

 

 

Cheers, I'll see how it works out.

[PC Nerd]

if you need more help, PM me