[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb30b

Title:VAX Rdb/VMS V3.0B
Notice:READ ONLY, WRITE to new conference BANZAI::RDB_31
Moderator:BANZAI::SMITHI
Created:Tue Jul 11 1989
Last Modified:Mon Apr 02 1990
Last Successful Update:Fri Jun 06 1997
Number of topics:1075
Total number of notes:5481

59.0. "Optimizer weirdness with SORTED BY on mixed area" by TAV02::HAGAR (Hagar Ronen-Zoref, Israel CSG) Mon Aug 14 1989 10:41

T.RTitleUserPersonal
Name
DateLines
59.1Not so silly when you see the cost $$YUPPY::HARRISONSSimon Harrison - another Kiwi abroadMon Aug 14 1989 11:5318
59.2Try thisSQLRUS::MOHAMEDMon Aug 14 1989 18:1012
59.3But with a FIRST n SORTED BY index field ?TAV02::HAGARHagar Ronen-Zoref, Israel CSGTue Aug 15 1989 07:0937
59.4Try this one tooSQLRUS::MOHAMEDWed Aug 16 1989 12:5217
59.5my solutionBERN01::WIDMERThu Aug 17 1989 03:3916
59.6But WHAT ABOUT THE first n CLAUSE ?!!!TAV02::HAGARHagar Ronen-Zoref, Israel CSGMon Aug 28 1989 10:1148
59.7I don't think the opt uses FIRSTN currentlyCOOKIE::OAKEYOAKEY :== WROBELMon Aug 28 1989 13:5023
59.8Could be done, but hasn't yetWIBBIN::NOYCEBill Noyce, FORTRAN/PARALLELTue Sep 12 1989 10:5219