1. In Sybase how i can find whether a table is locked or not?

2. How i can enforce table T to use index I?

3. In sybase how i can find all indexes associated to a table?

4. If table a has 9 million records. among 9 million 8 million records
have "stateName" column value equal to "NY". What is the best way to
delete all these 8 million record.?