RE: What are these indexes?

RE: What are these indexes?

 

  


If you create a primary or unique constraint within the body of a CREATE
TABLE statement, the syntax allows you to specify the constraint name, but
not the supporting index name, or indeed any useful index properties; this
is still the case at V9 and the probable origin of the system generated
names you mention below. Because CREATE TABLE allows you to specify neither
the index properties (allow reverse scans, clustering etc.) nor an index
name that fits in with site standards, my preference is to create the index
outside the create table, then ALTER TABLE to add the constraint and reuse
the index.
Regards
Alex Levy
Sustainable Software Ltd.
http;//www.sustainablesoftware.net




"Schleicher
Jeremy D. "
<db2udbdba-ezmlms To
hield-x57751711.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

22/11/2006 13:41 Subject
RE: What are these indexes?










The name is unique to your system. Their names are based on the time
the index was created. You will have to generate the ddl yourself to
determine what the columns are.

Jeremy Schleicher
ERP Database Administrator
Florida State University

-----Original Message-----
From: Andrew G Mclaughlin
[mailto:db2udbdba-ezmlmshield-x45581899.[Email address protected]
Sent: Wednesday, November 22, 2006 8:39 AM
To: LazyDBA Discussion
Subject: What are these indexes?


I am running DB2 V8 fp12 and I see indexes with names such as:
SQL050510111916340 in SYSCAT.INDEXES. I understand they must be system
generated, but can anyone tell me what they are and why they are
created?
I am trying to find an index to sort on for reorg, but it won't allow me
to
reorg on these indexes.

Thanks,
Andy



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page