Questions tagged [table-index]
25 questions
0
votes
3 answers
How to improve the performance of my query
The query below to get the distinct zip codes from the Address table takes roughly 4 mins and 42 seconds. There are 1,006,699 records in the Address table. The composite key for the table is Address1, Address2, City, ZipCode.
There have been times…
rds80
- 631
- 1
- 10
- 23
0
votes
1 answer
JQuery table search filter side effect: Messed navigation because of row indezes
I'm currently developing a table view to visualize and change warehouse stocks. Requirements are the following: sortable, searchable and navigation by side buttons (fast up, up, down, fast down). So I implemented the table and filled it with data.…
epanalepsis
- 853
- 1
- 9
- 26
0
votes
1 answer
MS SQL Server not using index when WHERE has IN with more than 6 values
So i have a very strange issue, If i run a query like this:
SELECT *
FROM tbl_x
WHERE tbl_x.SomeCode IN ('1','2','3','4','5','6')
The query uses the index on the table, however if i do query this:
SELECT *
FROM tbl_x
WHERE tbl_x.SomeCode IN…
Mike Bateman
- 360
- 2
- 9
0
votes
4 answers
Stored Proc /Table Index Improvement
I'm looking for some comments on a stored proc that we are using in our application. It gets called a lot and I think there is room for improvement. I'm also looking to see if adding an Index to Team and Opp would help with the SP.
We are running…
userStack
- 91
- 7
0
votes
1 answer
Index on (col1, col2) and Index on (col2, col1)
1/In a table, how would index I1 on T(col1, col2) be different from index I2 on T(col2, col1) ? Can we create both ? Take for example Unique Index.
Index Skip Scanning seems to dictate that the column order is important, meaning perhaps I1 would be…
Kenny
- 1,902
- 6
- 32
- 61
0
votes
1 answer
When we use global indexes and when we use local indexes in Oracle?
Can anybody explain me
When should we use global indexes ?
When should we use local indexes ?
Which indexes needs to be dropped before loading into table ?
Thanks
Srinivas P
- 31
- 3
- 9
0
votes
0 answers
How do I set indexes for MySQL queries (JOIN, GROUP BY, ORDER BY, MULTIPLE CONDITIONS)
For the below queries I already have a spatial index and indexes on the primary key (ID). Other than that I would like to know how I should set my indexes to make the below queries fast. In some cases the queries are very slow (more than 3 seconds).…
BastiaanWW
- 1,259
- 4
- 18
- 34
0
votes
1 answer
1st access to Oracle SP is very slow, subsequent access seem fine
Not sure if this question has been already asked. I face this problem where the 1st hit from the website to an Oracle SP takes a lot of time. Subsequent accesses work just fine.
The SP i'm taking about here is a dynamic SP used for Search…
KeenUser
- 5,305
- 14
- 41
- 62
0
votes
3 answers
How to get index name, key and description from sybase table
I want to create index for specific table from Unix shell script, so that I need index name, index keys, and index description for that particular table.
"sp_helpindexes" gives all these details with some unwanted lines, but I need alternative way…
Jayavinoth
- 544
- 1
- 9
- 24
0
votes
1 answer
EF 4.3.1 code first table index mapping or creation
I've been searchin around a lot for a way to create, or configure a specific index on a table from EF code first, but really can't find a thing. mapping fluent Api doesn't seem to expose any means to do this. What am I missing?
Amanda Tarafa Mas
- 1,043
- 8
- 13