Challenge: Creating B-tree Index
Swipe to start coding
We have considered in the previous chapter that the B-tree index can be created using the following syntax:
CREATE INDEX index_name ON table_name
USING BTREE (column_name1, column_name2,...);
Now let's continue working with the BankAccounts
table as in the previous chapter. Given that we frequently work with balance ranges when dealing with bank accounts, it would be beneficial to create a B-tree index on the balance
column.
Your task is to create a new B-tree index on the balance
column of the BankAccounts
table. Please ensure that you directly specify a B-tree index and do not rely on the default index:
- specify
balance_index
as the name of the index. - the index is created for
BankAccounts
table. - the index is created using
balance
column.
Oplossing
Bedankt voor je feedback!
single
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 4.35
Challenge: Creating B-tree Index
Veeg om het menu te tonen
Swipe to start coding
We have considered in the previous chapter that the B-tree index can be created using the following syntax:
CREATE INDEX index_name ON table_name
USING BTREE (column_name1, column_name2,...);
Now let's continue working with the BankAccounts
table as in the previous chapter. Given that we frequently work with balance ranges when dealing with bank accounts, it would be beneficial to create a B-tree index on the balance
column.
Your task is to create a new B-tree index on the balance
column of the BankAccounts
table. Please ensure that you directly specify a B-tree index and do not rely on the default index:
- specify
balance_index
as the name of the index. - the index is created for
BankAccounts
table. - the index is created using
balance
column.
Oplossing
Bedankt voor je feedback!
Awesome!
Completion rate improved to 4.35single