Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • All posts
  • InterSystems Official
    New
  • Announcements
  • Articles
  • Questions
  • More...
  • No answer
  • No accepted answer
  • With accepted answer
  • Discussions
  • Videos
  • Jobs
  • Jobs Opportunities
  • Jobs Wanted

InterSystems resources

  • Download InterSystems IRIS
  • InterSystems Container Registry
  • Early Access Program
  • Developer Hub
  • Share an idea
  • Become a partner
  • InterSystems IRIS Cloud SQL
  • InterSystems IRIS on AWS
  • InterSystems FHIR Server on AWS
  • InterSystems IRIS on Azure

Our social networks

  

#Indexing

1

How to index data structures in databases.

Month
  • Week
  • Month
  • Year
  • All time
AllTop
Question
Jean Millette · 21 hr ago
What's this odd behavior with "select count()" and a Unique Index?

Hello,

I have a class with a "Unique" index (pxfactidIndex) on a %Numeric property (pxfactid) (partially-edit code snippet below):

#Indexing #ObjectScript #SQL #InterSystems IRIS
0 7
0 67

Trending posts

Technology Bonuses Results for the InterSystems FHIR and Digital Health Interoperability Contest 2025
Evgeny Shvarov
45 186
Winners of the InterSystems FHIR and Digital Health Interoperability Contest 2025
Anastasia Dyubaylo
5 81
Integrate with Google Forms
Yuri Marx
2 41
Show more (2)
Use Mako Python template engine to generate dynamic content
Yuri Marx
2 39
Making Sense of Blood Tests with FHIRInsight: Turning FHIR into Clarity
Henry Pereira
2 31

Recently released

PivotSubscriptions
by Peter Steiwer
54818
iris-fhir-bridge
by Muhammad Waseem
111
SQL DATA LENS
by Andreas Schneider
1.2K
Featured
iris-vector-search
by Fan Ji
1.5K

News

Register today

  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up