combination.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question out of all this: Is there a way to convince the
optimizer that it is fine to use a range portion of the index to fulfill
this query?
Please let me know if there is something I've missed,
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list
| cc | biotech |
+-++-+
3 rows in set (0.01 sec)
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nM' command. But the resize will
choke on a datafile with active extents in that datafile.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
properly.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
an int is usually 4 bytes at worst while a
city name is definitely more than 4 bytes. Yes it does generate a second
table that only has the mappings from cityID to cityName, but you will likely
find it well worth the effort to use the mapping.
Brad Eacker ([EMAIL PROTECTED
development experience.
You may want to take a look at Teach Yourself SQL in 21 Days
by Stephens and Plew, Sams Publishing ISBN 0-672-31674-9 for the
copy that I have in front of me. It does a good job of explaining
these kinds of questions.
Brad Eacker ([EMAIL PROTECTED
21 years, and perl for 20 years. Yet these don't
appear to be enough to get a position in Silicon Valley.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL