🦙
🦙
Pinboard bookmarks for December 2011
u:onekCheck out the warning on the top of this wikipedia page - Keeping Up with the Kardashians - daveedelstein's posterous
2011-12-09 / 12 years ago
Check out the warning on the top of this wikipedia page - Keeping Up with the Kardashians
Â
2011-12-09 / 12 years ago
AlcoDroid Alcohol Tracker - Android Market
2011-12-15 / 12 years ago
would this app encourage me to drink less... or more? AlcoDroid Alcohol Tracker
Â
2011-12-15 / 12 years ago
DB2 System Catalog Views: Everything You Need to Know About Your DB Objects
2011-12-19 / 12 years ago
List all the indexes available for a given table
To get all indexes available in a given table, you can use the SYSCAT.INDEXES catalog view. The following query will display the index name, the user who created the index, the names of the columns included in an index, the number of columns in an index, whether an index is primary or not, whether an index is unique or duplicate values are allowed, the index type, etc.:
SELECT INDNAME, DEFINER, TABSCHEMA, TABNAME,
COLNAMES, COLCOUNT, UNIQUERULE, INDEXTYPE
FROM SYSCAT.INDEXES
WHERE TABSCHEMA NOT LIKE 'SYS%' AND
TABNAME = 'TABLE_NAME'
When you write queries to retrieve data from a table, use all the available indexes to improve performance. For that, you need to know all the columns in an index, the order in which they appear, and the sort order for each of the columns. To get all this information, you can use the SYSCAT.INDEXES and SYSCAT.INDEXCOLUSE catalog views as follows:
SELECT A.INDNAME, A.TABSCHEMA, A.TABNAME,
B.COLNAME, B.COLSEQ, B.COLORDER
FROM
SYSCAT.INDEXES AS A,
SYSCAT.INDEXCOLUSE AS B
WHERE A.INDSCHEMA = B.INDSCHEMA AND
A.INDNAME = B.INDNAME AND
A.TABSCHEMA NOT LIKE 'SYS%' AND
A.TABNAME = 'TABLE_NAME'
ORDER BY A.INDNAME, B.COLSEQ
db2 syscat sql info workÂ
2011-12-19 / 12 years ago
Feed43 : Convert any web page to news feed on the fly
2011-12-22 / 12 years ago
great online tool! Feed43: online service that converts any web page to an RSS feed (via @feed43)
Â
2011-12-22 / 12 years ago
great song from reddit - old guy sings "Where do I go now" - daveedelstein's posterous
2011-12-23 / 12 years ago
great song from reddit - old guy sings "Where do I go now"
Â
2011-12-23 / 12 years ago