RE: [sqr-users] Re-Indexing a Table in SQR

["Bob Stone" <bstone@fastenal.com>]

I think you can do the dbms_stats you just have to call it right.  I
don't think it's different than other procedures in SQR.  Although, if
it has reasonable stats in the first place, you may not need to
reanalyze it.

You're not saying you need to have an index on different columns, you
just need the stats reanalyzed, right?

BEGIN-SQL
BEGIN
  dbms_status("I forget the syntax");;
END;;
END-SQL



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Wright, David L. II
Sent: Thursday, May 11, 2006 12:56 PM
To: 'SQR Users Group'
Subject: [sqr-users] Re-Indexing a Table in SQR

Greetings all,
 
I have a situation where I need to re-index a table in SQR after loading
it.
There is no way to organize the input sequentially so therein lies my
problem.
 
Other than dropping the index and re-indexing (which is a no-no at our
site)
is there any other way to re-index a table inside an SQR?
 
I have already tried to run DBMS_STATS but SQR doesn't like that.
 
Thanks in advance for any help you can offer
 
 
David L. Wright, II
SAIC Sr. Technical Consultant, PeopleSoft

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users