As of May 31, 2023, we have updated our Code of Conduct.

Questions tagged [index-design]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

NoSQL : MongoDB : Design Collections for Countries and Generic Translations

We have a countries collection, where default language is English, containing the ISO 3166. Country document information can change over the time (ISO standards can change). Maybe adding "...
mntblau's user avatar
1 vote
1 answer

Postgres too Many References to Single Table is good or bad design

I have a Postgres database schema for a web app that needs real-time data and hence a huge volume of select, update, insert queries. Data manipulation is done via Postgres stored procedure mostly I ...
Smarhacker's user avatar
-1 votes
1 answer

Schema required to find a record in a table with null values

I have the following table. ID Country City Street No 1 UK 2 2 Lon 3 Oxf 19 4 UK Glas 5 US NY Wall 6 US NY 14 7 5 In this table, I have defined some address rules. For example. If ...
B Faley's user avatar
  • 101
0 votes
0 answers

Is a columnstore index appropriate when all columns are (mostly) unique?

I have a longish table ( 60M rows ) where there are only 7 columns. One is a unique ID, two are datetimes, and two are notes and descriptions. There the notes and descriptions are very regular, except ...
Clay's user avatar
  • 101
0 votes
1 answer

Should I use composite key or primary key from other table

We have a Education Project which has following entities : Domain (e.g. Programming, UI/UX, AI, ML), each Domain has 5 Levels (1, 2, 3, 4, 5) Building Blocks - which are like small topics e.g. java, ...
j10's user avatar
  • 229
1 vote
0 answers

Elastic: Are Analyzers only for `text` type fields?

Most of the documentation about Elastic Analyzers assumes that you NEED an Analyzer and so the documentation talks mostly about how Analyzers work and the differences between the different Analyzers. ...
Trevor Boyd Smith's user avatar
11 votes
1 answer

When to use multiple tables in DynamoDB?

The DyanmoDB best practices make it clear that: You should maintain as few tables as possible in a DynamoDB application. Most well designed applications require only one table. I find it amusing ...
David Eyk's user avatar
  • 517
3 votes
0 answers

Modeling a database structure for a trip management business domain

I am sketching up a database design and it is giving me some troubles. Basically something just "smells" about this design but I can't seem to arrive at a better way to do it. For example, the Joins ...
thehnrytrapezoid's user avatar
1 vote
1 answer

Hundreds of millions of rows: Index by composite BIGINT, VARCHAR, or CHAR of HASH?

Given the following: Target platform: MySQL 5.7, using InnoDB. Scenario: Storing hundreds of millions of email addresses (plus some properties not used in queries). All queries will be done by ...
marcelog's user avatar
  • 111
1 vote
1 answer

The Logical Type of The Document in CouchBase

How should the logical type of a document get specified in CouchBase? Using a field for the type? Or employing separators in keys like product::app::123id? Currently I'm putting a document type, ...
Kaveh Shahbazian's user avatar
2 votes
2 answers

Is it needed to add additional column to make this clustered index unique?

I have a table as listed below in SQL Server 2012. There is a clustered index on RequisitionID – but this column is not unique. There can be many ProductID for one RequisitionID. CREATE TABLE [dbo].[...
LCJ's user avatar
  • 899
1 vote
1 answer

Multiple Non-Indexed Views with INCLUDEs vs. Multiple Indexed Views in High Write Situations

When you want to encapsulate your T-SQL to select different subsets of data from the same base tables, is it more efficient to use plain views in conjunction with nonclustered indexes and INCLUDEs on ...
SQLServerSteve's user avatar
9 votes
1 answer

Is the WHERE-JOIN-ORDER-(SELECT) rule for index column order wrong?

I am trying to improve this (sub-) query being part of a larger query: select SUM(isnull(IP.Q, 0)) as Q, IP.OPID from IP inner join I on I.ID = IP.IID where ...
Magier's user avatar
  • 4,717