[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

David,

Are you dropping the table or deleting from it?  If dropping, your
indices are dropped as well and creating the table would require
creating the appropriate index as well.

In Oracle (my company's database of choice), up through 9i, Compute
Statistics will update your index.  For 10g on, it is supposed to be
automatically managed.  See here:
http://www.dba-oracle.com/t_index_statistics_create.htm

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu] 
Sent: Thursday, May 11, 2006 2:15 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Re-Indexing a Table in SQR


I would drop the index, load the table and then re-index.

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@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