>
> I did have a "normal" index on the mls_number, but I can see how "unique"
> would be better.
>

Yeh, if you can physically define what makes a row unique, do it (if you
can't define what makes a row unique, theres something wrong with the
table)! Let the database enforce that basic database rule - saves your ass
from duplicates down the line too :)

Dom


On 23/04/2008, Rick Faircloth <[EMAIL PROTECTED]> wrote:
>
> 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:304066
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