Stack Overflow
Stack Overflow

Questions tagged [table-index]

25 questions
6
votes
1 answer

Batch query to a GSI in DynamoDB?

Is it possible to create a single query on multiple hash key values simultaneously using DynamoDBMapper on a GSI? For example, if I'm trying to get all relevant records in a table Table using a GSI I'd iterate through all my hash key values and make…
Austin Guo
  • 167
  • 1
  • 12
4
votes
1 answer

Clustering Factor and Unique Key

Clustering factor - A Awesome Simple Explanation on how it is calculated: Basically, the CF is calculated by performing a Full Index Scan and looking at the rowid of each index entry. If the table block being referenced differs from that of the…
Maheswaran Ravisankar
  • 17,652
  • 6
  • 47
  • 69
3
votes
2 answers

a set indexed objects in ArrayList - is it possible?

Is it possible to create a set indexed objects in ArrayList? I want to create an array of objects - Portal class - and have them indexed in array which size will be defined by user. import java.util.ArrayList; import java.util.Scanner; …
hubesal
  • 141
  • 3
  • 13
2
votes
2 answers

Anyone know how to make the table index the first 4 chars of my core data name attribute?

I'm working on a coin app. Coins are presented to the user in a tableview, managed by Core Data. All the coin names begin with either "19" or "20". When I implement a section index on the table view, I only get a "1" and a "2" in my index. Pressing…
RyeMAC3
  • 1,023
  • 1
  • 10
  • 17
2
votes
0 answers

C# EF Index based on entity field and owned value object field

Any body know if it is possible to create index based on entity field and owned value object field using code-first in entity framework - dotnet core 3. I have entity with this 2 fields and several more: public string SomethingId { get; private set;…
vezuwio
  • 23
  • 3
2
votes
1 answer

dbWriteTable removes primary keys and indexes in MySQL

I create a MySQL table as follows: create table schema_name.test ( col1 varchar(10), col2 varchar(10), primary key (col1), index col1_index (col1) ) and I write a data.frame to the table using dbWriteTable as follows: > test <- data.frame(col1 =…
Rookatu
  • 1,487
  • 3
  • 21
  • 50
2
votes
2 answers

MySQL: Shouldnt using a routine to find a match be much faster in this example?

This query takes 0.0002 secs to execute: SELECT country,city FROM location WHERE locID = 30296 LIMIT 1 locID is obviously an INDEX. This other query uses a routine, and takes 0.0005 secs to execute (it returns 30296): SELECT…
Andres SK
  • 10,779
  • 25
  • 90
  • 152
1
vote
1 answer

How do I append a dollar sign to my sectionIndexTitlesForTableView?

I'm working on an app that displays entries in a Core Data table by dollar figure. I sorted my table by a dollar figure attribute. I also use that as the basis for the table index. At first I made my titles for my table sections strings. But that…
RyeMAC3
  • 1,023
  • 1
  • 10
  • 17
1
vote
1 answer

UITableView: Can't find a way to move/align the tableIndex element up

I have a UITableView and I am using a tableIndex, my problem is that when the keyboard comes up, it partially hides the tableIndex. An acceptable solution would be to move the tableIndex up (like what the Contacts App does) when the keyboard…
Ignacio Oroná
  • 4,371
  • 1
  • 19
  • 25
1
vote
4 answers

Drop a column from table problem (SQL Server 2008)

Unable to delete [U_Family] column from table below : Table CREATE script: CREATE TABLE [dbo].[Users]( [U_Id] [int] IDENTITY(101,1) NOT NULL, [U_Name] [nvarchar](50) NULL, [U_Family] [nvarchar](50) NULL, CONSTRAINT [PK_Users] PRIMARY…
Farzin Zaker
  • 3,578
  • 3
  • 25
  • 35
1
vote
2 answers

Using a sub-string of the column name in creating index in CockroachDB

Moving from Oracle to CockroachDB, I'm using a index creating command as below: CREATE INDEX ON "sales" (substring("a",0,19), substring("b",20,2), "c"); The error I get is: invalid syntax: statement ignored: unimplemented at or near ")" CREATE INDEX…
Cyrus
  • 912
  • 2
  • 11
  • 21
0
votes
1 answer

MySQL: MATCH AGAINST is not showing all results

I have a strange problem - I use MySQL 5.1 and a table with Fulltable-Index. In the mysql config, ft_min_word_len is set to 2 (so words with a length of at least two characters are indexed). The queries below are simplified, but have the same effect…
Stefan
  • 337
  • 6
  • 20
0
votes
1 answer

what happens to partitioned local indexes after a table partition is dropped oracle

I have a requirement to drop multiple partitions for a table every month. The table has been partitioned based on the year and month and has partitioned local indexes 1.since the indexes are local ,I believe they get dropped with the partition and…
user9668693
  • 11
  • 4
0
votes
2 answers

How to optimize complex calculation query execution time?

I have a query like this : SELECT *, ( 6371 * acos ( cos ( radians(33.577718) ) * cos( radians( `Latitude` ) ) * cos( radians( `Longitude` ) - radians(115.846524) ) + sin ( radians(33.577718)…
Budianto IP
  • 1,118
  • 1
  • 13
  • 27
0
votes
1 answer

Extracting unique result and reducing cost in star schema in postgres

I have following star schema which has bunch of tables involved as shown below to determine availability of book in a library f_book_availability (This table consist of availability of books with references to other dimension table which i will…
Sandeep Nair
  • 436
  • 2
  • 15
1
2