sql server - Perfomance Issuses on Tables With NonClustered Index -


We have a table with nearly 100,000 records that are often used in our applications. We had an identity column and had a package index on it and used to do everything well, but for some reasons we had to use a unique identity column as the primary key. So we add a non-cluster based index to it and remove the package indicator on the id column. But now, there are lots of performance degradation in our time from our customers, is it because the table no longer has a package index?

This means that you had to leave the package index, two concepts are different. You have a unique identifier, Can be implemented by non-indexed indices and different package indexes of elections (such as old id columns).

But the real question is, when you add a unique identifier, PK how did you change your application? Have you modified the application code to get the record through this new PK (Unique Identifier)? Have you included everyone in the context of the new PK? Have you modified all foreign key cosntraints which refers to the old id column? Or does the application continue to retrieve data using the old identity, id column? My expectation is that you have changed both into applications and table, and now there is a table in the table with "SELECT ..." table WHERE pk = @ uniqueidentifier As is now prevalent. If such access is reached, only , then the table should not be corrected with a non-clustered unique identifier primary key and a package index. Therefore, there should be something else on play:

  • Your application is reaching the table based on old identity code ID
  • old identity code column
  • your query is referencing the old key code in the old id column

    Ultimately you have a problem solving problem and see it as a performance troubleshooting problem. I have two great resources for you: and

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more