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 ...
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 ...
Top 50 recent answers are included
Related Tags
database × 862mysql × 145
microsoft-excel × 137
linux × 69
sql × 67
sql-server × 63
postgresql × 61
microsoft-access × 59
windows × 43
database-administration × 34
backup × 28
worksheet-function × 24
ubuntu × 23
windows-7 × 22
networking × 20
sqlite × 20
macos × 18
microsoft-excel-2010 × 18
vba × 14
spreadsheet × 14
phpmyadmin × 13
query × 13
odbc × 13
php × 12
csv × 12