Index_J

J

Java API, 625–644

connection methods, 627–629

example, 642–644

general methods, 625–626

ResultSet methods, 633–639

ResultSetMetaData methods, 639–641

SQLException methods, 641–642

statement and prepared statement methods, 629–633

Warning methods, 642

JOIN statement, 490

join_buffer_size variable, 383

joining tables, 32–35

joins, 29, 67, 84–96

calculating number of rows needed to search, 164

EXPLAIN statement to indicate type, 159–161

full outer, 89

inner, 86

left (left outer), 87–89

natural, and USING keyword, 90– 91

normalization and, 237

optimizing, 164–169

returning results found in only one table, 91–92

right (right outer), 89

sub-selects, 94–95

rewriting as joins, 95–96

UNION to join results, 92–94