Data Tables and Indexing

Anvil Q&A
1

Meredydd, Ian,

Can you give us some insight about Data Tables and indexing? There’s no option in the IDE to define indexes, so what’s going on behind the scenes? Is every column I create indexed?

2

Is every column I create indexed?

In short: Yes :slight_smile: Every search(column=value) query is indexed.

(It’s not as inefficient as you might think; it all hits a shared GIN index.)

3

Thanks for the info Meredydd! Speaking of performance, I’m on the Anvil Individual plan. Were I to upgrade to the Business or Dedicated plan with their respective dedicated server, isolated databases, etc., would my application automatically run faster?