The index tag has no wiki summary.
0
votes
0answers
33 views
Would this 'IN' use unique index in SQL
In a case, I need SQL like this, in Mysql, innodb engine:
**select** code, title **from** my_table **where** code **in** ('cx001', 'kd309', 'yb020');
The column code has a unique index. Would the ...
0
votes
0answers
8 views
Table Partitioning in MySql and Hibernate
In my project I have a table with around 20 columns. We have partitioned table on column 'status'. For the sake of simplicity let's say there are two possible values of status "ERROR" and "SUCCESS". ...
0
votes
1answer
17 views
how many type of index in oracle and uses of hash index in oracle
How many types of indexing are in Oracle, and what is a HASH INDEX and how does it compare to other indexes ?
0
votes
1answer
17 views
mysql join not use index for 'between' operator
So basically I have three tables:
CREATE TABLE `cdIPAddressToLocation` (
`IPADDR_FROM` int(10) unsigned NOT NULL COMMENT 'Low end of the IP Address block',
`IPADDR_TO` int(10) unsigned NOT NULL ...
0
votes
1answer
33 views
find duplicate values in a NSMutableArray
how to know how many times a duplicate appears in my array ?
for (NSUInteger index = 0; index < count; index++)
{
NSDictionary *dico = [myArray objectAtIndex:index ];
NSString *exp = ...
1
vote
1answer
17 views
Set which rows to delete on mysql after applying combined unique index w/ignore
Supose I have a table with several columns.
I know how to find duplicates, and then to keep just one record with this expression, adding a combinated index...
ALTER IGNORE TABLE part3 ADD UNIQUE ...
1
vote
7answers
80 views
Equivalent to index for enum type in c#?
Say I have the following enumerated type:
private enum ranks { ace = "Ace", two = "2", three = "3", four = "4", five = "5", six = "6", seven = "7",
eight = "8", nine = "9", ten ...
1
vote
1answer
36 views
PHP associative array index undefined
Without looping a set of array keys acquired via array_keys($array), how else can I select the key of an array such that $array["key"] where "key" associates to a second subsequent array -- PHP ...
0
votes
0answers
3 views
Reverse Index/Match -or- jumping back 1 cell in Index/Match
This started as a just-for-fun formula in a work spreadsheet, but I couldn't figure it out... Simplified (hopefully), I have a row with months (Jan-Dec) and a row below with dollar values. For this ...
0
votes
2answers
27 views
Removing duplicates from MySQL on a column that's too big to INDEX
I'm trying to remove duplicate rows from a table with millions of rows. The field I want to check for duplicates on is too long (it's storing URLs) to put a UNIQUE index on. Is there any way to ...
0
votes
1answer
36 views
C++ Linked List: IndexOf of an object
I am trying to find an index of a given object in my linked list.
I want to return -1 is the object doesn't exist in my list.
Below is my code, please guide me.
int List::indexOf(const Object& o) ...
1
vote
0answers
35 views
return index less than a threshold value in numpy array?
Is there corresponding method to these function in numpy?
def arg_less(inarray,threshold):
return np.nonzero(inarray<threshold)
def arg_greater(inarray,threshold):
return ...
-3
votes
0answers
25 views
Oracle 11g FILTER BY on columns from different tables [closed]
Possible Duplicate:
Oracle 11g Text: Composite Domain Index - FILTER BY on columns from different tables
In Oracle 11g, can we use FILTER BY on columns from different tables...
or
...
0
votes
0answers
25 views
Excel Use VBA to inject filename into INDEX function to be able reading out closed documents
I'm addressing a problem with EXCEL 2010. I've got a customer who has for every employee an excel file, where they store the working time and holidays.
Now I need to create an additional EXCEL file ...
0
votes
3answers
53 views
looping over list of lists without nesting too much
So I have a list of lists called a, and I want to save the indices of an item inside that list in a tuple. for example, if a[0][0] = 1, then i would like to save (0,0) and save into that list.
Right ...