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,

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