What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));

What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));
Creates an index for efficient case-insensitive searches on the titles column within the books table
Well Done. Your Answer is Correct Keep it Up!
Nothing, it’s invalid SQL
Creates a non-write-locking index
Creates a new index with a special operator class ‘lower’ for case insensitive comparisons.

Leave a Reply

Your email address will not be published. Required fields are marked *