> >Question 2: If not, what would the Insert/Select statement look like that > would copy the records over in sorted order? > > > Tables aren't sorted. Period. > > > > Only result-sets can be sorted.
While that is true, strictly speaking, packing data into the same physical order as you expect to logically access it is a fairly common optimization for data which remains fairly static. Having said that, for the 1600 records reffered to here, I doubt there would be any observable difference. -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]