New answers tagged database
0
votes
Accepted
How to convert a simple VLOOKUP to XLOOKUP in Excel?
First things first:
Your VLOOKUP() function shown in OP will certainly return wrong output from 14 th row onwards. The second parameter of VLOOKUP() function is table_array which needs to be either ...
- 2,028
1
vote
Accepted
how to optimize DB query for table with millions of rows when info is sorted (sorted by date in this case)
To take a first run at optimization:
Update your index to:
CREATE INDEX date_index ON messages_table (date_column DESC);
WHERE DESC seems to be the desired (non-reversed) sort order for the column ...
- 26
Top 50 recent answers are included