Very curious about this too. Corruption of indexes does occur but less than a handful of times in my 30 years of DBA experience, and is usually due to hardware failure or some immediate cause.
Script the table and provide the query.
On Sat, Oct 29, 2022, 8:16 AM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
Actual table definition, sample query, and output, please.
--
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxxx
https://www.linkedin.com/in/scottribe/
> On Oct 29, 2022, at 5:20 AM, abbas alizadeh <ramkly@xxxxxxxxx> wrote:
>
> I faced the same issue last week.
> We had duplicated records on primary key.
