l.com
Subject: Re: Which is better
On 8/2/2011 02:41, Adarsh Sharma wrote:
> Dear all,
>
> Just want to know which join is better for querying data faster.
>
> I have 2 tables A ( 70 GB ) & B ( 7 MB )
>
> A has 10 columns & B has 3 columns.Indexes exist on both tables'
On 8/2/2011 02:41, Adarsh Sharma wrote:
Dear all,
Just want to know which join is better for querying data faster.
I have 2 tables A ( 70 GB ) & B ( 7 MB )
A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.
select p.* from table A p, B q where p.id=q.id
or
select p.* fro
is optimizer depend on size of table? not sure
On Mon, Aug 1, 2011 at 11:48 PM, Shafi AHMED wrote:
> I hope the former better.
> Test with query plan output, though
>
> Best Rgs,
> Shafi AHMED
>
>
> -Original Message-
> From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
> Sent: Tuesday
I hope the former better.
Test with query plan output, though
Best Rgs,
Shafi AHMED
-Original Message-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Tuesday, August 02, 2011 12:12 PM
To: mysql@lists.mysql.com
Subject: Which is better
Dear all,
Just want to know which jo
At 08:54 AM 7/13/2006, abhishek jain wrote:
Dear Friends,
I was to create a site with quite some heavy mySQL database.
I wanted to know which is better longer rows in a table or two short rows
tables.
When compared in terms of speed etc.
Pl. help me , with this question and any other tip you ma
Not sure what your question is, but remember you can use indexes to speed up access to rows. Thus usually the less fields you need
to seach in the better, avoid OR searches across fields.
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 13, 2006
* [EMAIL PROTECTED]
> Case A:
...
> This statement would probably be much larger (upto 150 lines) and would
> query one table without additional joins.
>
> Case B:
>
> Here, when a user enters a city, the soundex of it is created and then
> queries a table that contains every city in the db PLUS al
Hi,
May the following sql statement is more efficient.
SELECT * FROM bc_posts WHERE
post_citysoundex IN('A265','A415',.)
Armand
motorpsychkill wrote:
I need to have a user input a city and have MySQL pull up any records with
that city OR nearby cities (within 10 mi). Which of the following
