Most voted "índices" questions
Indexing data structures is a general technique to improve the speed of data searches. A database index contains keys built from one or more columns in the table or view, and pointers that map to the storage location of the specified data.
Learn more…111 questions
Sort by count of
-
2
votes1
answer1751
viewsImprove slow query performance on MS SQL SERVER
The indexes are incorrect? I’m having trouble optimizing a consultation. I had done another question for a simpler case that solved, but for this case I’m not getting a better result. The following…
-
2
votes1
answer213
viewsHow to repeat number at a maximum?
I have two whole: n and m: n: Number that will repeat in the index; m: Index maximum. What I need to do is simple, is to return a number that is <= m on the basis of n. When n is larger, it will…
-
2
votes2
answers121
viewsRepeat loop with problem
I have the algorithm below, and on the line while lista[i]==lista[i-1]: is returning the error: index out of range import random n1=0 n2=0 n1=int(input('Insira um numero para inicio'))…
-
2
votes1
answer135
viewsSubistituir dynamic table row
In the catch line function I pick up the clicked line and send the data to the form and store OBJ from the line and get index tbm var index = $(obj).closest('tr').find('td').eq('0').text(); Here…
-
2
votes1
answer42
viewsWhat are covering, Composite and compound compared to Dexes?
I’m reading on Left in Mysql and I came up with three terms that I can’t quite understand that are: covering, Composite and compound. These terms are strongly linked to the use of Dexes, however, I…
-
2
votes2
answers171
viewsDelete and relocate index
How should I associate data to have a db SQL Server 2017 with a good performance. I am doing a data association and being new in this area I feel a little lost. I have the following structure as an…
-
2
votes1
answer220
viewsModify the indices of each item in a Treeview Java FX or Treeview.getSelectionModel() override method. select(int index)?
Greetings to all. This is my first post here. I am developing a Java FX project that consists of a form with a Treeview whose items are obtained from an Arraylist, previously completed through a…
-
2
votes4
answers669
viewsHow to access indexes backwards within a list?
I’m taking the notes that make up the triads of the major chords. For this, I created a list of all possible notes, and according to the chord typed I see the list looking for the first largest,…
-
2
votes1
answer21
viewsSQL Index Unico
I have a question on SQL Server. I have the following table, ID (integer Key), Name (nvachar), CPF (nvachar, with index unico). If I insert with the CPF that already exists, SQL returns with error…
-
1
votes1
answer845
viewsSelect in SQL Server with Intel
I wonder if it is possible to select in Sql Server a table that does not have an index column, but in this select display a sequential index column in ascending order. Ex. Table: Lettering Coluna D…
-
1
votes1
answer563
viewsHow to check if a name is in the database?
I want to check if a name exists in the database; if there is no registration. Using the code below I can register several users with the same name. php. $user = $_POST['user']; $pass =…
-
1
votes1
answer88
viewsIn the index used in the query / prepared statement
I have a strange Warning in my code, when there is only one data in DB it recognizes and works well, but when I insert more than 1 data in DB it shows me the following Warning: No index used in…
-
1
votes1
answer415
viewsHow to see the disk space that the index occupies in the database?
I have the table maintenance with the column id_product (varchar(MAX)), however the same is not the primary key, the table has 900 thousand records so I decided to create indices to optimize…
-
1
votes3
answers245
viewsResolver undifined index
I’m trying to create one table with data from a database mysql, but when I open the page, it shows some results and then above appears this error: Notice: Undefined index: TASK DESCRIPTION in C:…
-
1
votes2
answers540
viewsPython: index 5324 is out of Bounds for Axis 0 with size 5040
Hello, everybody, I have a Python code that reads the 5040 numbers of a TXT file to perform a simulation, as shown in Figure 1. Then the code creates a B(s) function, which is used in the commands…
-
1
votes1
answer1147
viewsIndex making sql query too slow
the DBMS in question is SQL Server In my system, we have a table that stores book releases. The table has a considerable amount of records, currently (around 1.2million). Has an index clustered over…
-
1
votes0
answers122
viewsWhich best Mysql index
Hello I have a question about explain, index in mysql Real Estate Table 47.240 Table of Order of Attendance 1,887,421 SELECT SQL_NO_CACHE COUNT(*) FROM imoveis I INNER JOIN situacao_cod_venda SCV ON…
-
1
votes1
answer948
viewsHow to add up the values of an index?
I am new in python and need to make a program that add the digits that belong to the same position of a list, for example: Lista = ['22659', '387685', '89546'] The result of the list sum[0] would be…
-
1
votes1
answer16
viewsRestarting indexes for each new client
I need help from you. I have a small system that allows the registration of companies, and each one can contain one or more members. See a summary of the tables: //Tabela Empresa emp_codigo (chave…
-
1
votes1
answer449
viewsDoes Mysql work with more than one index?
If I have a query in a table: SELECT * FROM clientes WHERE empresa_id=10 AND datacad='2017-01-01' And two indexes, one in the column 'empresa_id' and another in 'datacad'. Mysql will use only one of…
-
1
votes1
answer67
viewsDifficulty loading sections in cellForRowAt
I’m having a little difficulty in implementing indexes (A through Z) in my app... See the structure below, what should I do to properly load the indexPath.section?: struct EmployeeDetails { let…
-
1
votes1
answer19
viewsMongodb driver C# Index not used
In Mongodb: db.estr.createIndex({_id:1, Atualizar:-1}); In C# var a = await db.dados.Distinct(x=>x.codigo).toListAsync(); var b = await db.estr.find(x=>!a.contains(x._id) &&…
-
1
votes0
answers820
viewsWhat is the significance of Overhead in physical database design?
I just read about physical design and database adjustment and could not understand the concept of overhead, and consequently could not understand what the author of the book wanted to explain. I…
-
1
votes3
answers166
viewshow to find the indexes of an item that repeats in a list in Python
have a list l = [1,6,6,2,3,6] and I want to form another with all the indexes of the element 6. In this case, the second list should be l2 = [1,2,5], however, when I try to use the l.index(6),…
-
1
votes0
answers126
viewsIs it worth using index for table in Mysql that stores chat messages?
Friends, I read several posts about the use of the index in the tables of the Mysql database, its advantages and disadvantages, but I still had a question for my situation. Consider over 300,000…
-
1
votes1
answer879
viewsVBA Excel - Index Match with two conditions
I have a spreadsheet with several tabs. In the first tab I have the following table: In tab 2 type the client and the type, and I wish to return the ID. For this I am using the following code in…
-
1
votes0
answers124
viewsError validating if the selected datagridView Index is null
I’m having difficulty feeding a dataGridView with objects, where I need to list properties of another object. as for example: PRODUCT.CODE, PRODUCT.DESCRIPTION, REQUEST.VALUESARY. The only solution…
-
1
votes0
answers38
viewsTrying to program puzzle changing elements into equivalent positions of two error arrays
I’m trying to make a puzzle in which the image comes scrambled into pieces, and by clicking on two different pieces they change position, if the drawing is correct it goes to the next. But the…
-
1
votes1
answer49
viewsExtract attributes from a dataframe using the points of a second dataframe
Greetings. I’m trying to extract information from biomes from a dataframe (biomes_df), which has columns of temperature and precipitation. I want to use these values to extract which biomes the…
-
1
votes1
answer50
viewsHow to access the index correctly for data in the same file?
I have a file txt file.: >gb:KX262887|Organism:Zika virus|Strain Name:103451|Segment:null|Subtype:Asian|Host:Human GTTGTTGATCTGTGTGAATCAGACTGCGACAGTTCGAGTTTGAAGCGAAAGCTAGCAACAGTATCAACAG…
-
1
votes2
answers53
viewsHow I take information from within an Array from the index
In this example I already have the numbers of indexes of elements within an Array, but with these numbers I need to get the information out of the Main Array. This amount of indexes is variable, so…
-
0
votes1
answer147
viewsComposite index - M:N in Ruby on Rails
I need to add a double index to the ratio N to N, from the table courses_internships. would be more or less like this: add_index[:course_id, :internship_id]. However, when I created the link table,…
-
0
votes2
answers1723
viewsHow to remove index through . htaccess file from site?
Hello, I am making a site and I would like to remove the index by changing to another address ex: site.com.br/Uritiba - WITHOUT USING REDIRECTION IN CPANEL. I am looking for a solution in . HTACCESS…
-
0
votes2
answers1453
viewsIndex views in Mysql
I have a view in my Mysql database, I would like to know if it is possible to index the fields that are contained in it, because I have a group by on it that is consuming much, and a index would…
-
0
votes1
answer258
viewsAccessing Viewbag list via Javascript
I am trying to access the elements of a list stored in Viewbag as follows: function equipamentoTemControle() { for(i = 0; i < @ViewBag.qtdEquipamentos; i++) { var contratocod =…
-
0
votes1
answer138
viewsphp undefinex index
index.html Customer Registration <!-- Bootstrap --> <link rel="stylesheet" href="css/bootstrap.css"> </head> <nav class="navbar-default navbar navbar col-lg-12"> <div…
-
0
votes1
answer129
viewsHow do I make Google not index this script?
Hello! I started using a script on my wordpress site to display advertisements of an advertising network, the problem is that when I went to webmaster tools I noticed that the script is making…
-
0
votes1
answer131
viewsProblem using cakephp 2.6 - Undefined index
Good morning friends, I am learning to program on cake recently and I am having some difficulties. Follow models and controllers. Recibo.php (Model) class Recibo extends AppModel{ public $name =…
-
0
votes0
answers76
viewsMysql - What is the best input to be created in this case
Hello, I have a table in the database with the product price history. This table is very voluminous having more than 1 billion records. How can I create an index in this table, to meet the query…
-
0
votes1
answer30
viewsIndexing BD records
I recently circled a EXPLAIN ANALYZE in my database which is fairly large, about 800mil records in some tables, and I noticed that the indexing methods adopted were not the best. I always let the…
-
0
votes1
answer1276
viewsTake the column values of the clicked row and pass inputs
Here is the function to take the table row value, and pass to inputs, if I take the lines that were loaded from the error database but when, insert a new item into the table, then I take the value…
-
0
votes1
answer452
viewsForce Postgresql to use an index, how?
There is a way to force Postgresql to use a specific index? I have two equal tables (different servers, of course), with the same indices created in each one, however, in one server the index is…
-
0
votes1
answer58
viewsCreate different indexes for different searches - Mongodb
Hello, At another time I needed to get posts similar to a specific blog I’m developing, and this similarity was governed by the tags used in each post. Using Mongodb, I achieved this by creating an…
-
0
votes1
answer548
viewsIndexerror: list index out of range Python
I’m getting the following error: IndexError: list index out of range My code: conts = conts[0] if imutils.is_cv2() else conts[1] How can I correct this mistake? Complete code…
-
0
votes0
answers33
viewsError creating GIN type index
When trying to create an index of type GIN in a table I came across the following error: CREATE INDEX idx_descricao on produtos USING gin (descricao gin_trgm_ops); ERRO: classe de operadores…
-
0
votes1
answer53
viewsUse Indexfieldnames in FMX
I’m trying to use the IndexFieldNames inside the FMX to organize the data according to the column but when calling the method HeaderClick, I can’t get the Column name and only its content. Using…
-
0
votes1
answer71
viewsPython: How to assign values in n arbitrary dimensions?
I have two n-dimensional arrays (i.e. Len(A.Shape)==Len(B.Shape)), and one 'fits' in the other (be the first A, the second B, for all dimensao i of A and B, A.Shape[i]>=B.Shape[i]) I want to…
-
0
votes1
answer118
viewsMongo indexes
I am starting the studies with the indexes. I have a base in Mongodb where the documents have about 10 fields. Searches can be done using all these variables. I created an index with all fields, and…
-
0
votes0
answers50
viewsImpact using INDEXES in Mysql
I have a table that currently has 25 million records, due to this any query I do however simple it is becomes very slow. I was researching about INDICES to improve search performance and found that…
-
0
votes1
answer441
viewsHow to get the index comparing two lists of different lengths in Python?
I have two different lists in two CSV files. The first list has 47843 items and the second 813331, which is the first multiplied by 17. I want to take the index position in the first, based on the…