Questions tagged [indexing]

10

votes

4

answers

SQL Server Table Synonyms with Indexes

asked 2009-09-01T14:53:44.660

17

votes

4

answers

SQL Server - index on a computed column?

sql-server sql-server-2008 indexing calculated-columns

asked 2009-08-24T15:56:42.607

45

votes

3

answers

Are unique indexes better for column search performance? (PGSQL & MySQL)

postgresql mysql hash indexing

asked 2009-08-18T12:22:51.177

1334

votes

13

answers

What do clustered and nonclustered index actually mean?

sql-server performance indexing clustered-index non-clustered-index

asked 2009-08-09T15:59:41.927

14

votes

3

answers

When does Oracle index null column values?

oracle-database indexing null

asked 2009-08-05T01:46:33.587

22

votes

6

answers

"Stop words" list for English?

language-agnostic indexing filtering stop-words nlp

asked 2009-08-02T07:19:16.323

12

votes

1

answers

INDEX in Postgres?

postgresql indexing

asked 2009-07-30T22:24:56.053

20

votes

4

answers

Mysql performance on 6 million row table

mysql performance indexing

asked 2009-07-11T20:51:22.440

42

votes

11

answers

Is array both associative and indexed?

javascript arrays indexing associative

asked 2009-07-02T20:59:28.087

10

votes

5

answers

Full Text Search primer?

database indexing full-text-search

asked 2009-06-26T17:11:14.560

39

votes

10

answers

Using an enum as an array index in C#

c# indexing enums

asked 2009-06-11T15:22:21.383

192

votes

2

answers

What does the KEY keyword mean?

mysql indexing

asked 2009-05-29T03:31:13.607

21

votes

3

answers

What does the COLLATE keyword do when creating a sqlite index?

sql sqlite indexing collate

asked 2009-04-28T21:11:31.203

117

votes

14

answers

Does an index of this array exist?

c# arrays indexing

asked 2009-04-27T18:43:49.570

18

votes

4

answers

What are the disadvantages of having many indices?

sql database sqlite indexing rdbms-agnostic

asked 2009-04-18T21:08:04.337

11

votes

2

answers

Why does the cardinality of an index in MySQL remain unchanged when I add a new index?

mysql indexing full-text-search cardinality

asked 2009-04-16T10:43:45.237

9

votes

5

answers

Using both a GUID and an auto-incrementing integer

sql-server database indexing primary-key guid

asked 2009-04-03T15:28:47.503

25

votes

3

answers

What are some best practices and "rules of thumb" for creating database indexes?

database database-design indexing

asked 2009-03-26T23:55:10.713

22

votes

6

answers

How to copy indexes from one table to another in SQL Server

sql sql-server database indexing

asked 2009-03-16T21:03:25.917

375

votes

21

answers

How can I remove an element from a list?

r list indexing r-faq

asked 2009-03-16T20:59:36.223

38

votes

3

answers

Primary key Ascending vs Descending

sql-server indexing primary-key

asked 2009-03-16T04:57:37.813

22

votes

2

answers

Is primary key always clustered?

sql sql-server indexing primary-key

asked 2009-02-24T11:59:37.190

48

votes

9

answers

How can I manipulate MySQL fulltext search relevance to make one field more 'valuable' than another?

mysql search indexing full-text-search relevance

asked 2009-02-13T20:26:32.860

13

votes

5

answers

Python file indexing and searching

python search indexing lucene

asked 2009-02-10T13:27:29.307

9

votes

8

answers

Does making a primary key in multiple columns generate indexes for all of them?

oracle-database indexing primary-key multiple-columns

asked 2009-02-10T12:04:21.953

12

votes

10

answers

Compress sorted integers

indexing compression integer

asked 2009-02-07T13:15:09.910

185

votes

10

answers

Does Foreign Key improve query performance?

sql sql-server performance indexing foreign-keys

asked 2009-02-03T14:03:27.570

12

votes

7

answers

How to update a Lucene.NET index?

vb.net indexing lucene lucene.net

asked 2009-01-24T16:16:05.043

62

votes

2

answers

Are UNIQUE indices case sensitive in MySQL?

mysql indexing key unique case-sensitive

asked 2009-01-21T01:06:41.450

12

votes

1

answers

Thoughts on index creation for SQL Server for missing indexes

sql sql-server-2008 indexing performance

asked 2009-01-14T17:18:14.403

63

votes

2

answers

MySQL 5.0 indexes - Unique vs Non Unique

mysql indexing

asked 2008-12-23T14:27:27.493

39

votes

13

answers

No indexes on small tables?

sql sql-server indexing performance

asked 2008-10-31T08:21:13.243

9

votes

4

answers

How do you run Lucene on .net?

java .net search indexing lucene

asked 2008-10-31T00:34:15.697

30

votes

12

answers

Do any databases support automatic Index Creation?

mysql database indexing

asked 2008-10-23T21:05:45.287

35

votes

6

answers

How to choose and optimize oracle indexes?

oracle-database optimization indexing

asked 2008-10-17T14:01:59.233

117

votes

5

answers

How to create a unique index on a NULL column?

sql sql-server indexing constraints unique

asked 2008-10-10T14:03:34.287

32

votes

11

answers

What are the different types of indexes, what are the benefits of each?

sql database database-design indexing

asked 2008-09-25T20:12:25.530

13

votes

6

answers

How do you know what a good index is?

database oracle-database indexing

asked 2008-09-17T02:22:41.527

40

votes

1

answers

PostgreSQL: GIN or GiST indexes?

postgresql indexing gwt-gin gist-index

asked 2008-08-22T05:22:39.610

81

votes

3

answers

What's the difference between a Table Scan and a Clustered Index Scan?

sql sql-server indexing

asked 2008-08-20T20:38:50.283

66

votes

9

answers

How do I index a database column?

sql database indexing

asked 2008-08-04T11:21:26.567

26

votes

2

answers

Why doesn't SQL Full Text Indexing return results for words containing #?

sql sql-server sql-server-2005 indexing full-text-search

asked 2008-08-04T05:51:56.683

Questions tagged indexing