Reputation
Next tag badge:
93/100 score
51/20 answers
Badges
11 81 184
Newest
 Enlightened
Impact
~7.0m people reached

47m
awarded  Enlightened
2h
awarded  Nice Answer
16h
reviewed Close PL/SQL error: PLS-00103: Encountered the symbol “EXCEPTION”
17h
comment How to speed up query containing concat() in WHERE clause?
How much free RAM do you have ???
17h
comment How to speed up query containing concat() in WHERE clause?
Run SELECT data_length,index_length FROM information_schema.tables WHERE table_schema = 'database_where_table2_resides' AND table_name = 'table2';. What is the output ?
17h
revised MySQL Index Creation Internals
added 1395 characters in body
17h
revised MySQL Index Creation Internals
added 413 characters in body
17h
reviewed No Action Needed Copy a large data from sql query result
18h
reviewed Leave Closed Can we create indexes on views in SQL Server?
18h
answered how to increase speed of this mysql query?
19h
comment How to speed up query containing concat() in WHERE clause?
I have two questions : 1) How much RAM does the DB Server have ? 2) What is your key_buffer_size ? Please run SHOW GLOBAL VARIABLES LIKE 'key_buffer_size'; to find out.
19h
answered How to speed up query containing concat() in WHERE clause?
20h
revised How to speed up query containing concat() in WHERE clause?
edited tags
21h
reviewed Close Does the transaction log grow during a full backup?
23h
reviewed Close How to convert voice data into text file in hadoop?
1d
reviewed Reject Why is SELECT * much faster than selecting all columns (in a different column order) by name?
1d
reviewed Leave Closed Grouping based on the status, then count its product and the total based on its category ID
1d
reviewed Reviewed Do I need a database license for my application?
1d
comment Do I need a database license for my application?
I'm voting to close this question as off-topic because it's about Licensing
1d
reviewed Close How to make sqlplus more user-friendly anyone?