sybperl-l Archive

From: B1AXPA5 at BAFCO dot BELL-ATL dot COM
Subject: Re: Re-Creating Sybase Indexes
Date: Mar 6 1996 11:48PM

     Creating indices is a server activity.  The best way to solve your
     problem is to create a stored procedure on that table for creating
     indices.  Then you only need to send a single sql command to kick it
     off.

     Hope this would help.

     Nick Duan
     Bell Atlantic
     Internet Services Center of Excellence


______________________________ Reply Separator _________________________________
Subject: Re-Creating Sybase Indexes
Author:  owner-sybperl-l@trln.lib.unc.edu at INTERNET
Date:    3/6/96 5:58 PM


Attachment file number 1, file name
Creation date:  March 06, 1996 17:59:07
Document Type:  ASCI, Document Class: MEMO
Author:
Comment:        Re-Creating Sybase Indexes
Level:          1, Number : 1



I'm considering writing a function in sybperl which will accept the
name of a database table and return a transact-SQL statement which
could then be used to re-create all the indexes on that table.   Does anyone
know if such a function already exists and if so, where I might find it?
I running Perl 4.035 and sybperl is 1.31.

Thanks
Tony Byorick

Tony Byorick
NationsBank
Baltimore, Md.


----------------------------------------------------------------