RE: Hi Query Optimization steps

>-Original Message- >From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] >Sent: Wednesday, August 26, 2009 5:08 AM >To: mysql@lists.mysql.com >Cc: bharani kumar >Subject: Re: Hi Query Optimization steps > >Hi! > > >bharani kumar wrote:

Re: Hi Query Optimization steps

Hi! bharani kumar wrote: > Then which DB engine is better. > Which fruit is better, an apple or a banana? And if X is better, why do farmers still grow Y, and why do people buy it? More serious: Different engines offer different features, as described in the manual. The most obvious diff

Re: Hi Query Optimization steps

Then which DB engine is better. Thanks On Mon, Aug 24, 2009 at 8:16 PM, mos wrote: > At 05:01 AM 8/22/2009, you wrote: > >> Hi all >> >> Tell Me few Query Optimization Tips >> >> For example.. some people saying that , avoid using more of and condition >> in >> the query >> > > Hu

Re: Hi Query Optimization steps

At 05:01 AM 8/22/2009, you wrote: Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query Huh? You need to carefully plan your table structure and use indexes sparingly on the columns you are using in the Whe

Hi Query Optimization steps

Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query This sort of very basic things please tell me ... Also tell me , in the optimization view ,, which database engine is best Thanks Bharanikumar