Hello,

> If my data base has a table that is related with ten other tables and,
> in each one of these ten tables exists one field that I have that to
> show together in a consultation with the first table. What of this two
> options goes to give the best performance?

Well, basically, the one that gives you the best performance is the
one that gives you the best performance.

Given that you did not create any indices or keys, I suspect performance
(on non-empty tables with a substantial number of rows) is bad in either
case.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com