SQL Optimizer for SAP ASE SQL Worksheet

Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...