nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CalculateStatistics does not work on Query Table

GKmieliauskas

Hi,

I have "QueryTable" type table on enterprise database. I would like to calculate some statistics on it. CalculateStatistics method throws exeception "A geodatabase-related exception has occurred".

The same code with exported to gdb table works fine.

Does anyone have experience in working with statistics on QueryTable type tables?

Find more posts tagged with

Accepted answers

All comments

Wolf

Which Enterprise database are you using and what type of statistics are you trying to get?

Aashis

Thank you for bringing the issue to our attention @GKmieliauskas. We logged it as a bug, and our dev team will investigate the cause, and then we will let you know the solution or any workaround to the issue.

GKmieliauskas

Thank you for the information.

I have another one issue related to "QueryTable" type table. GetCount from table takes about 40s on 3600 records when on the same structure of regular table it takes a moment to count rows. There is no difference to call GetCount or walk thru Search cursor and count records by myself. Is it specific to "QueryTable" or something wrong in implementation?

P.s. I have found that my "QueryTable" isn't registered with the geodatabase. Could registration help me with performance issue?

GKmieliauskas

We have solved issue with GetCount by indexing primary table field.

Aashis

@GKmieliauskas What enterprise geodatabase are you using? Is it SQL Sever?

GKmieliauskas

Yes, it is SQL Server

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.