Well... in this case, all of the properties have a unique mls_number,
so that would work for the property tables.  I did have a "normal" index
on the mls_number, but I can see how "unique" would be better.

Thanks for the help!

Rick

> -----Original Message-----
> From: Dominic Watson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 23, 2008 3:43 AM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
> 
> Just a note on indexes - every one of your tables should have at least one
> unique constraint or index *other* than the primary key. This way, the
> primary key is not what makes a row in your table unique - it just
> identifies it for relationship purposes.
> 
> This helps to avoid duplicate data and helps speed up query performance as
> you have found :)
> 
> HTH
> 
> Dominic
> 
> 
> On 23/04/2008, James Holmes <[EMAIL PROTECTED]> wrote:
> >
> > Did you try the UNION ALL as suggested by Rizal? This might make it a
> > little quicker as the DB won't have to scan for duplicates.
> >
> > On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth
> > <[EMAIL PROTECTED]> wrote:
> > > If I had set up the original db that's providing the
> > >  data, it would have definitely been set up differently.
> >
> > --
> > mxAjax / CFAjax docs and other useful articles:
> > http://www.bifrost.com.au/blog/
> >
> >
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to