FKs are constraints. They really are there to ensure that the data in the FK exists in the other table. They do not operate like a conventional index that is there to aid in selecting data.
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-10-21, at 7:24 AM, Karl DeSaulniers <karl@xxxxxxxxxxxxxxx> wrote:
> Excuse me for intruding, but wouldn't this be a Foreign Key solution?
> If one field is the same on all tables, can't you just set a Foreign Key
> that all tables with that field get their data from?
> Then you only have to query the master table??
> Or an I not grasping the idea behind Foreign Keys.
> I am still learning.
> TIA
> HTHS
>
> Karl
>
> On Oct 21, 2010, at 6:12 AM, Bastien wrote:
>
>> Alternatively, you could try setting that index on each table and use a UNION to join multiple queries together provided each query returns the identical data set structures ( or the column types have to match)
>>
>> Bastien Koert
>> 905-904-0334
>> Sent from my iPhone
>>
>> On 2010-10-21, at 7:06 AM, Artur Ejsmont <ejsmont.artur@xxxxxxxxx> wrote:
>>
>>> I dont think you can create such index across tables.
>>>
>>> If you are interested read up on sphinx. Im pretty sure you would be
>>> able to create what you need.
>>>
>>> Alternatively ... a super simplistic solution ..... create one extra
>>> search table with copy of the data and create index there? ;P hehehe
>>> + would let you do what you need
>>> - would require a lot more IO to support the extra writes (to keep copy in sync)
>>>
>>> It would be cool if a fulltext index could be created on a view :)
>>>
>>> Art
>>>
>>> On 21 October 2010 09:43, Ron Piggott <ron.piggott@xxxxxxxxxxxxxxxxxx> wrote:
>>>> Is it possible to create one index on multiple tables? I am trying to create a search function for my web site. The data the user needs to be able to search is stored in multiple tables. I would like to be able to use "MATCH / AGAINST", like the query below I found online.
>>>>
>>>> SELECT firstname, lastname,comments FROM users WHERE MATCH(firstname,lastname,comments) AGAINST ('$searchterm')
>>>>
>>>> Ron
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
