Multiple column Indexes for a table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-04-2024 05:36 AM
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.
Can anyone please confirm if the above will work without any impact (performance etc.) to the functionality? compared to the individual indexes?