Skip to main content David Edelstein's Blog


Pinboard bookmarks for December 2011

Published: 2011-12-31
David Edelstein
AlcoDroid Alcohol Tracker - Android Market
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
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
great online tool! Feed43: online service that converts any web page to an RSS feed (via @feed43)
2011-12-22 / 12 years ago