Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2011-11-28 : 12:11:31
|
| I ran a query to find overlapping indexes and it revealed many indexes that appear to have been made by some software I was using (Quest SQL Optimizer). The indexes don't show up in the list of indexes using SSMS and when I try to drop them it says they either don't exist or I don't have permission. There are about 20 of them named like this...QUEST_SX_IDX_3C109F8A18FDF969DDo they actually exist? Can I get rid of them? Why don't they show up in the list of indexes?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-28 : 12:17:43
|
| can you spot them in sys.indexes?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-11-28 : 12:28:18
|
quote:
Originally posted by visakh16
can you spot them in sys.indexes?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Yes. They are there.Apprently they are "hypothetical" which is why they don't show up in SSMS. Should I just delete all hypothetical indexes? Seem to get permission denied though...UPDATE: Can't seem to delete them from the table either..."Ad hoc updates to system catalogs are not allowed" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-28 : 13:05:38
|
quote:
Originally posted by ferrethouse
quote:
Originally posted by visakh16
can you spot them in sys.indexes?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Yes. They are there.Apprently they are "hypothetical" which is why they don't show up in SSMS. Should I just delete all hypothetical indexes? Seem to get permission denied though...UPDATE: Can't seem to delete them from the table either..."Ad hoc updates to system catalogs are not allowed"
you cant do it directly from tableyou need to useDROP INDEX indexname ON table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2011-11-28 : 13:35:06
|
| Worked! Thanks for your patience and guidance. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 03:14:58
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
hidden indexes