 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 3 matches |
| Author | Message |
|---|---|
 Topic: INDEX scan or Table Scan |
|
| pharia01 Replies: 4 Views: 2599 |
 Forum: Database Posted: Fri May 25, 2007 5:15 pm Subject: INDEX scan or Table Scan |
| Videlord,
based on the statistic information, if requested data are more than 25% of total records, DB2 optimizer will use table scan instead of index scan just curious, where did you get ... |
|
| Topic: Help in SQL Query |
|
| pharia01 Replies: 5 Views: 3215 |
Forum: Database Posted: Wed May 23, 2007 1:34 am Subject: Help in SQL Query |
| Piscesian,
In this case, to be able to group by the derived column, refer to a sample example# 6 at http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQJ14/4.2.6?SHELF=&DT=20061213 ... |
|
| Topic: Select with a few 'Left' Joins - need help with last join |
|
| pharia01 Replies: 14 Views: 7653 |
Forum: Database Posted: Sun May 20, 2007 4:08 pm Subject: Select with a few 'Left' Joins - need help with last join |
| NASCAR9,
Try following untested query. SELECT CHAR('321') ,CURRENT DATE ... |
|
All times are GMT - 5 Hours |