Pinboard bookmarks for December 2011

Check out the warning on the top of this wikipedia page - Keeping Up with the Kardashians

would this app encourage me to drink less... or more? AlcoDroid Alcohol Tracker

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

great online tool! Feed43: online service that converts any web page to an RSS feed (via @feed43)

great song from reddit - old guy sings "Where do I go now"