Thanks for providing some info for the database. But still i have some questions why some tables have no clustered Index ? And high logical reads with clustered index scan . Is it possible to create/alter index on the existing tables based upon the execution plans .
Please see KB73614 for our stance on custom indexes. In a nutshell you're welcome to add your own indexes, but we can't help you with troubleshooting them and you're responsible for maintaining them.
The link worked for me fine. You can go to kc.mcafee.com and look up any of the kb articles. Some require that you be logged into the service portal first, but most do not.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?