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

[Les Hancock <les_hanc@yahoo.com>]

Something like this may do it:
   
  begin-sql
    analyze table sysadm.ps_L_KK_ACTVTY_LOG estimate statistics 
      sample 15 percent  for table for all indexes 
      for all indexed columns
  end-sql
   
   
  If the table is large, it may take a while.
   
   
  You probably should verify that command with your DBA's.
   
   
  Hope that helps,
   
  Les


"Wright, David L. II" <DAVID.L.WRIGHT.II@saic.com> wrote:
  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


                
---------------------------------
Blab-away for as little as 1¢/min. Make  PC-to-Phone Calls using Yahoo! 
Messenger with Voice.

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