PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Durairaj K dot Avasi" <webdurai at webdurai dot com>
Subject: question.
Date: Jul 16 2004 1:59AM

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.?
 
 
Thanks and Kind Regards
Durairaj K. Avasi