ca.portal.admin

Question about indexes for SQL-defined database

Discussion created by ca.portal.admin on Feb 17, 2006
An SQL-defined index can contain columns that are potentially null.
Where does a null field fall in the collating sequence for an index?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: HPSPO query
"Thanks Iain and Pete for your responses.
You have validated my understanding of storage management/protection. I guess the underlying question I have is; if I convert my production regions asis, storage protection on for the system and off at the program level, will I still enjoy the storage efficiencies that I have had with pre-release 16.0? or has the storage management software been rewritten, to facilitate HPSPO, so that the 'system on/program off' method no longer provides the same level of CPU efficiencies?

Thanks again,

Bill Boyce

Outcomes