python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - b-tree-index

How to apply the index line "my_table_<custom_name>" btree (<comma, separated, fields>) to a table?

I am managing a postgres db created by third parts. One of the tables is described as \d my_table; Table "my_table" ... Indexes: "my_table_pkey" PRIMARY KEY, btree (dt, ida...
test-img

Tms91

database

postgresql

indexing

b-tree

b-tree-index

Votes: 0

Answers: 1

Latest Answer

The two last lines indicate indexes, which were created after the table was created, with the following commands: CREATE INDEX my_table_fa ON my_table(dt, idd, idt, idfa, fnc); CREATE INDEX my_table_...
test-img

Tms91

Posts

Questions

Blogs

Jobs