Top "Indexing" questions

Does Foreign Key improve query performance?

Suppose I have 2 tables, Products and ProductCategories. Both tables have relationship on CategoryId. And this is the query. SELECT p.…

sql sql-server performance indexing foreign-keys

How important is the order of columns in indexes?

I've heard that you should put columns that will be the most selective at the beginning of the index declaration. …

sql sql-server sql-server-2005 tsql indexing

Disable intellij indexing on specific folder

In my project I have .deploy folder which is created/updated when I deploy my app locally. Is it possible …

indexing intellij-idea

How can I find all indexes available on a table in DB2

How to find all indexes available on table in db2?

indexing db2

What's the difference between using INDEX vs KEY in MySQL?

I know how to use INDEX as in the following code. And I know how to use foreign key and …

mysql indexing key

c++ uint , unsigned int , int

Hi I have a program that deals alot with vectors and indexes of the elements of these vectors, and I …

c++ indexing int iterator unsigned

Is the primary key automatically indexed in MySQL?

Do you need to explicitly create an index, or is it implicit when defining the primary key? Is the answer …

mysql database indexing key

SQL Server: how to write an alter index statement to add a column to the unique index?

I have a UNIQUE, NON CLUSTERED index on a table that is currently using 4 columns for the index. I want …

sql-server-2005 indexing alter

SQL Server indexes - ascending or descending, what difference does it make?

When you create an index on a column or number of columns in MS SQL Server (I'm using version 2005), you …

sql sql-server optimization indexing

MySQL indexes - what are the best practices?

I've been using indexes on my MySQL databases for a while now but never properly learnt about them. Generally I …

mysql indexing query-optimization