RE: Need help with indexing !

2004-04-16 Thread Victor Pendleton
Why not try to create a full text index on the column? -Original Message- From: jeroen clarysse To: [EMAIL PROTECTED] Sent: 4/16/04 9:00 AM Subject: Need help with indexing ! Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called

Need help with indexing !

2004-04-16 Thread jeroen clarysse
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called 'value') is usually between 50 and 150 characters, but occasionally jumps to a current maximum of 570 characters, so I figured I had to go for the TEXT type. now I tried to add an index o

Re: Help with indexing

2004-02-18 Thread Sasha Pachev
Better list? This is the best list on the internet! :-) Well, there is a "better" list - [EMAIL PROTECTED], but you have to buy a support contract to post :-) -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Help with indexing

2004-02-18 Thread Chris Nolan
Hi! Eric B. wrote: Hi, I'm trying to implement the proper indexing for my DB, and am having some challenges. I was hoping someone could lend me a hand. If I have 5 fields in the DB that I am indexing (field1, field2, field3, field4, and field5), I know I can create an index: Key Index1( field1,

Help with indexing

2004-02-18 Thread Eric B.
Hi, I'm trying to implement the proper indexing for my DB, and am having some challenges. I was hoping someone could lend me a hand. If I have 5 fields in the DB that I am indexing (field1, field2, field3, field4, and field5), I know I can create an index: Key Index1( field1, field2, field3, fie

RE: Help with indexing

2002-06-16 Thread Peter Normann
Sorry for not mentioning it, but yes I have indexed manager.Person... Peter Normann -Original Message- From: httpd [mailto:httpd] On Behalf Of Joseph Bueno Sent: 16. juni 2002 10:54 To: Peter Normann Cc: [EMAIL PROTECTED] Subject: Re: Help with indexing Peter Normann wrote

Re: Help with indexing

2002-06-16 Thread Joseph Bueno
Peter Normann wrote : > > Hello, > > I have a query I hope somebody can help me optimize. I have two tables > (given example): > > CREATE TABLE area ( > Area_ID INTEGER UNSIGNED, > Master INTEGER UNSIGNED > ); > > CREATE TABLE manager ( > Manager_ID INTEGER UNSIGNED, > Person INTEGER UN

Help with indexing

2002-06-16 Thread Peter Normann
Hello, I have a query I hope somebody can help me optimize. I have two tables (given example): CREATE TABLE area ( Area_ID INTEGER UNSIGNED, Master INTEGER UNSIGNED ); CREATE TABLE manager ( Manager_ID INTEGER UNSIGNED, Person INTEGER UNSIGNED, AreaINTEGER UNSIGNED ); I have