Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [indexes]

38 questions
20
votes
4 answers

How to exclude indexes from backups in SQL Server 2008

Our nightly full (and periodic differential) backups are becoming quite large, due mostly to the amount of indexes on our tables; roughly half the backup size is comprised of indexes. We're using the Simple recovery model for our backups. Is there…
Jarrod Dixon
  • 685
  • 2
  • 13
  • 23
8
votes
2 answers

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a script run daily which measures fragmentation…
SuperCoolMoss
  • 1,252
  • 11
  • 20
5
votes
2 answers

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the structure of the DB in order to get some…
RateControl
  • 1,207
  • 9
  • 20
5
votes
6 answers

Method for finding unnecessary indexes of an operational SQL Server database?

Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create table indexes which don't make sense for the running…
splattne
  • 28,348
  • 19
  • 97
  • 147
4
votes
3 answers

Why is Apache ignoring the "Options Indexes" directive?

I have the following block in my .conf file but when I load the appropriate URL (which points to a directory with just a dummy .txt file in it) I get the Apache 2 Test Page instead of a directory listing.
Teflon Ted
  • 500
  • 2
  • 7
  • 18
4
votes
2 answers

Find MySQL indexes without cardinality

I've recently found a few queries in my slow query log that should have been using indexes. When investigating the indexes in phpmyadmin it shows a null or empty cardinality. I'm unsure what causes this, but I need to find a way to identify this…
Noodles
  • 1,356
  • 3
  • 18
  • 29
4
votes
1 answer

Listing MySQL JOINS with no index

Is there a way to generate a list of JOINS being performed without indexes in MySQL?
Andrew Winter
  • 261
  • 4
  • 12
4
votes
4 answers

If I drop my clustered PK and add a new one, what order will my rows be in?

In SQL Server, I'm looking at TableA, which currently has a uniqueidentifier clustered primary key. The GUID has no meaning in any context. (I'll give you a second to clean up your keyboard and monitor and set down the soda.) I'd like to drop that…
stack
  • 143
  • 4
3
votes
3 answers

Apache directory listing only for specific IPs?

How can I enable Indexes only for specific IP addresses? Generally, I want directory listing to be disabled but only be enabled for a specific IP
mark
  • 1,516
  • 4
  • 21
  • 33
2
votes
2 answers

Suggested indexes

I am new to indexing in general and have just started learning about query plans etc. I am working on this one specific query that keeps advising me to create the following index: CREATE NONCLUSTERED INDEX [] ON…
Owain Esau
  • 83
  • 7
2
votes
1 answer

Why is "Options Includes Indexes" Enabled by Default in Apache?

I was curious as to why Options Includes Indexes is generally enabled by default in Apache configurations. Anyone know why this is, as it's generally frowned upon for security reasons?
tacotuesday
  • 1,349
  • 1
  • 14
  • 26
2
votes
1 answer

Rails program is not being run on apache + passenger - only directory listing

I have successfully installed Phusion passenger + Apache 2 + Rails 3.1 program + git on a linux Debian 6. I ran passenger-install-apache2-module and followed the configuration instructions. I followed also the setup instructions at…
user909943
2
votes
2 answers

sys.dm_db_missing_index_stats reports existing index

I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ... The following query returns missing indexes that are actually created on the tables. select * from sys.dm_db_missing_index_details where database_id =…
electricsk8
  • 65
  • 5
2
votes
1 answer

When to use a new index in Graylog (Elasticsearch)?

I have been searching for days now to find a good explanation on how indices are used by Graylog/Elasticsearch and when to create a new one. There is a lot of info about sharding indices but not much about the indices themselves apart from that they…
Holly
  • 133
  • 7
1
vote
1 answer

Different cardinality after each ALTER TABLE;

There is no new entries in this table. Same error on 10.3.8-MariaDB and 10.2.6 What could cause that? Also this is strange too.
Ollie
  • 68
  • 9
1
2 3