Re: SQL OPTIMIZATION ARTICLES/SOURCES REQUESTED

cantu@its.bldrdoc.gov writes: > I am looking for any sources of information >on the topic of SQL code optimization: examples of >SQL code(such as, SELECTS and UPDATES) and more >efficient means of achieving the desired outcome, >articles on results of tests showing how SQL code >optimization can improve overall system performance, >article on table structure optimization, etc. > Any help would be appreciated. >Send correspondence to cantu@its.bldrdoc.gov > Thanks, > Jonathan Cantu > > If it's so you can write SQL code that runs well then you should get a look at all back issues of _EXPLAIN_ magazine. 575 Madison Avenue, NY 10022 (212) 605-0442 Also good is _Database Programming & Design_ 500 Howard Street, San Francisco 94105 (415) 397-1881 If you want to write database software code to optimize queries then check back issues of the _ACM Transactions on Database Systems_ -- Dick Wilmot Editor, Independent RAID Report (510) 938-7425