A
A
aiwan92014-03-19 16:18:47
PostgreSQL
aiwan9, 2014-03-19 16:18:47

What is the efficiency of PostgreSQL index NULLS FIRST?

I want to understand whether there will be a performance increase when using an index:

CREATE INDEX test_idx
   ON test USING btree (column ASC NULLS FIRST);

in case the query
CREATE * FROM test WHERE column IS NULL;
will be executed frequently?
The question is: will the options ( NULLS FIRST , NULLS LAST ) have any performance impact? I didn't find it in the documentation about
it .

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question