0
 Followers
12
 Likes

Automatic Index on Is Active Attribute

Backend
New

When you select the Is Active Attribute on an entity it automatically starts to add the {Entity}.<IsActive fieldname> = True condition to all of the new aggregates

Then it should automatically create an index on that field to improve performance on the queries

Best regards,

PC

Created on 1 Mar (4 weeks ago)
Comments (7)

I suspect that an index will not improve performance at all on this value type, but I'm not a DBA.

J.Ja

No this will not improve performance, see this article. Queries use one index per joined table, so the performance can only be improved when the Is_Active column is added to a existing index, but only when there are a lot of inactive records.

Changed the category to Backend


Mathias -

Thanks for confirming my suspicions!

J.Ja

Ok, since we've established this Idea is actually a bad one based on false premises, can we Delete it Pedro?

Why would we want to delete it?

Marked it as out of scope, but deleting ideas seems wrong just by the principle of it

Best regards,

PC

Why delete it? Like I said, if it's based on a false premise, it has no value retaining it?

views
166
Followers
0