Multiple column Indexes for a table

venkatesh tadip
Tera Contributor

Hi Guys,

I have a query regarding the table Indexing.

As per a requirement, I am planning to create a Index for two different columns in a table .

Table-1

Column-A

Column -B

Can we create a single Index for both A and B:

Index(I): A and B.

venkateshtadip_0-1707053613783.png

Can anyone please confirm if the above will work without any impact (performance etc.) to the functionality? compared to the individual indexes?