meta user
network profile
| bio | website | |
|---|---|---|
| location | Vancouver, Canada | |
| age | ||
| visits | member for | 1 year, 10 months |
| seen | 9 hours ago | |
| stats | profile views | 63 |
|
1d |
answered | Database structure for tags? |
|
May 7 |
answered | Is it possible to validate DML statements? |
|
May 6 |
comment |
Same Parameter in MySQL Stored Procedure @ManishSapkal: Can you post the latest version of your procedure, ` OtherTable` and Users tables ddl, and execution plan for your select statement ? |
|
May 4 |
comment |
Same Parameter in MySQL Stored Procedure @Manish Sapkal : Since you didn't provide execution plan, I can only guess. The most likely culprit [in my opinion] is "parameter sniffing" - procedure compiles ones on first execution, and optimizer chooses the best (from it's opinion - not 100% accurate) plan that fits passed parameters... Without having all the details it's hard to answer your question. |
|
May 3 |
comment |
MySQL - Index on a query with ordernew_places_on_wishlist is redundant because id is primary key, and you use INNODB engine; thus, it's stored with each secondary index anyway (wishlist_place_unique has id implicitly ) |
|
May 3 |
answered | Same Parameter in MySQL Stored Procedure |
|
May 2 |
comment |
mysql varchar index - will hashing value make it faster? Did you consider creating a hash index on your varchar column instead of traditional b-tree index? |
|
May 1 |
answered | Foreign Key to Multicolumn Primary Key? |
|
May 1 |
accepted | Using dynamic sql inside Oracle stored procedure |
|
Apr 30 |
asked | Using dynamic sql inside Oracle stored procedure |
|
Apr 25 |
answered | Enforce indirect relationship |
|
Apr 15 |
comment |
Multiple like conditions for same column? Oracle has REGEXP_LIKE (docs.oracle.com/cd/B14117_01/server.101/b10759/…) . |
|
Apr 15 |
revised |
getting error when i use merge statement added 210 characters in body |
|
Apr 15 |
answered | getting error when i use merge statement |
|
Apr 15 |
awarded | Custodian |
|
Apr 15 |
reviewed | Approve suggested edit on getting error when i use merge statement |
|
Apr 14 |
answered | database design- diagrams |
|
Apr 10 |
comment |
Why is a “non-single-group group function” allowed in a subselect but not on it's own? I guess it's a bug in Oracle11 parser/optimizer (it's probably too smart and ignores product_id in inline view) . Both of them fail in Oracle10g ("not a single-group group function"). |
|
Apr 7 |
answered | Reinsert data in new table with new IDs |
|
Apr 3 |
awarded | Popular Question |
