Quote:
Originally Posted by Comedian2004
Some of the tables are not really tables, but are in a sort of way. What I mean is, they are treated as tables, but there is no look up file.
Good example is the pitchers 'pitches', there is no dump that contains the actual pitchers, 'fastball, slider, etc.', but it is treated like a table.
Is this what you mean?
|
I know what you're saying... There are some fields that are enumerations (i.e. they hold a value that corresponds to items on a list, but those items are not stored in a table), but I'm not certain what it has to do with indexing tables.
For the queries above, all that is required is that you take a full MySQL file dump and run the files against your MySQL database. From that point on, once they become a physical table in a MySQL database, I am considering that a table.
The code just creates some indexes on those tables, which will enable them to run a little faster when you are doing JOINs or other routine things.