| Author | Message | ||
     Jodhaa Side Hero Username: Jodhaa Post Number: 6656 Registered: 02-2008 Posted From: 75.185.75.109 Rating: N/A |
 Ninna thappu anipinchindhi, repu correct avvachu..adhey ninna correct anipinchindhi, repu wrong kooda kaavachu | ||
| Tinku Junior Artist Username: Tinku Post Number: 663 Registered: 08-2008 Posted From: 198.133.100.133 Rating: N/A |
 Congi - poyyyi kottimera currry tini raaaa sallla badatavu....... Phd - Nenu already salla ga unna...oka Kadapa bomb vesuko nuvvu notlo....annee set avuthaayi... | ||
| True Junior Artist Username: True Post Number: 11 Registered: 04-2008 Posted From: 65.217.188.20 Rating: N/A |
I think what you are seeing are not fully blown indices, but 'pseudo'-indices which sql server creates as placeholders, to represent column statistics. Amongst other things, statistics store things such as the distribution of the most significant data, and is used by the query optimiser to help decide its execution plan. Normally the auto-creation of these is not a problem, however, the database option auto-create statistics will disable sql server creating them for you. This is not recommended unless you intend to compensate for this by periodically creating and updating the statistics yourself. Maybe someone else can explain what determines whether statistics appear in sp_helpindex or sp_helpstats During my brief tests I was not able to reproduce my statistic indices so that they appeared in the resultset of sp_helpindex. However, one thing I did encounter was two 'hypothetical' indices remaining on one of my tables. These are used by index tuning wizard and should always be dropped after index tuning wizard has completed (the result of a crashed index tuning wizard, or a bug in an earlier service pack). So I learnt something new too | ||
| Sachin Side Hero Username: Sachin Post Number: 4346 Registered: 04-2008 Posted From: 68.100.141.8 Rating: N/A |
correctgaa theliyadu jodha...BTw what is the diff b/n clustered and non clustered  | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6623 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
YEP..I know sachin..kani ikkada issue non-clustered ga create avuthundhi..it should be clustered right? No one can make you feel inferior without your permission, remember they are no better | ||
| Tinku Junior Artist Username: Tinku Post Number: 645 Registered: 08-2008 Posted From: 198.133.100.130 Rating: N/A |
Doubt adigithey kooda meerey adagala?  ee wk ki work ayyipoyindi naadi.intiki vachhesa. Congi - poyyyi kottimera currry tini raaaa sallla badatavu....... Phd - Nenu already salla ga unna...oka Kadapa bomb vesuko nuvvu notlo....annee set avuthaayi... | ||
| Sachin Side Hero Username: Sachin Post Number: 4345 Registered: 04-2008 Posted From: 68.100.141.8 Rating: N/A |
jodha..table ki pK meeda index automatic gaa create ayyidi... | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6621 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
Tinku, doubt aduguthey kindal enduku chesthunnavu?Doubt adigithey kooda meerey adagala? No one can make you feel inferior without your permission, remember they are no better | ||
| Tinku Junior Artist Username: Tinku Post Number: 644 Registered: 08-2008 Posted From: 198.133.100.130 Rating: N/A |
 Congi - poyyyi kottimera currry tini raaaa sallla badatavu....... Phd - Nenu already salla ga unna...oka Kadapa bomb vesuko nuvvu notlo....annee set avuthaayi... | ||
| Cocanada Side Hero Username: Cocanada Post Number: 4421 Registered: 01-2008 Posted From: 136.181.195.17 Rating: N/A |
 "What makes you is what you love. Not what loves you" - Donald Kauffman | ||
| Cocanada Side Hero Username: Cocanada Post Number: 4420 Registered: 01-2008 Posted From: 136.181.195.17 Rating: N/A |
 "What makes you is what you love. Not what loves you" - Donald Kauffman | ||
| Batthar_bindaas Side Hero Username: Batthar_bindaas Post Number: 7561 Registered: 12-2006 Posted From: 155.94.62.222 Rating: N/A |
 | ||
| Jodhaa Side Hero Username: Jodhaa Post Number: 6620 Registered: 02-2008 Posted From: 208.11.223.20 Rating: N/A |
chinna issue okati find out cheyyagaligaamu..When we a new table is created using Erwin, automatic ga PK meedha Non-clustered index create avuthundhi...from the last 3 months idhi memu asalu observe cheyyaledhu..kani when we created a schema out of that model & created a new DB,observe chesthey, most of the tables ki PK non-clustered ga create ayyendhi... any idea's how to fix this? No one can make you feel inferior without your permission, remember they are no better |
