Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Why column crdate of sysindexes table show NULL

2 posts in General Discussion Last posting was on 2009-08-26 15:00:28.0Z
Matt Posted on 2009-08-26 11:21:37.0Z
Sender: 76a6.4a951a10.1804289383@sybase.com
From: Matt
Newsgroups: sybase.public.ase.general
Subject: Why column crdate of sysindexes table show NULL
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a951ac1.76cb.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Aug 2009 04:21:37 -0700
X-Trace: forums-1-dub 1251285697 10.22.241.41 (26 Aug 2009 04:21:37 -0700)
X-Original-Trace: 26 Aug 2009 04:21:37 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28222
Article PK: 77466

Hi,

Does any one has any idea why crdate of sysindexes table
shows NULL value while it should show either creation date,
or index rebuild date any changes to indexes.

The sybase ASE version is 12.5.3 on ESD 6 running linux 64
bit.

--Matt


Bret Halford [Sybase] Posted on 2009-08-26 15:00:28.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Why column crdate of sysindexes table show NULL
References: <4a951ac1.76cb.1681692777@sybase.com>
In-Reply-To: <4a951ac1.76cb.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a954e0c@forums-1-dub>
Date: 26 Aug 2009 08:00:28 -0700
X-Trace: forums-1-dub 1251298828 10.22.241.152 (26 Aug 2009 08:00:28 -0700)
X-Original-Trace: 26 Aug 2009 08:00:28 -0700, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28224
Article PK: 77468


Matt wrote:
> Hi,
>
> Does any one has any idea why crdate of sysindexes table
> shows NULL value while it should show either creation date,
> or index rebuild date any changes to indexes.
>
> The sybase ASE version is 12.5.3 on ESD 6 running linux 64
> bit.
>
> --Matt

The crdate field was added in the 12.5 GA release; the most likely
explanation was the table/index was created on an earlier version.

-bret