Very urgent, a query SQL takes 1.5 h away a full table scan, that there is a index table, and the in-CodePudding

me check into that table, table is very big, and check the column with index above, for help, very urgent

CodePudding user response:

First to determine why not go index, what is your statement,
Can try to look at the statistics

CodePudding user response:

The SQL and index information and execution plan posted and have a look

CodePudding user response:

The index information is listed on the table

CodePudding user response:

1. The statistics confirm accurate
2. Try to hint force index see release the query speed?

CodePudding user response:

Nima 9 indexes, large table query slow suggested that partition