Reputation
3,894
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
6 17
Newest
 mysql
Impact
~279k people reached

Apr
8
awarded  mysql
Mar
31
comment Student Attendance, null not returning
@Ali Shaikh : search for pivoting.
Mar
30
comment Student Attendance, null not returning
@ Ali Shaikh: something like AND attendance.Date IN ( '2015-03-30','2015-03-31') should do the job.
Mar
30
answered Student Attendance, null not returning
Mar
27
comment In USER_INDEXES but not in USER_IND_COLUMNS
LOB ? orafaq.com/forum/t/80334/2
Mar
17
comment Joining two inline functions, slows considerably when filtering on second function
@Jweaver: You need to check actual execution plan in each case to get an exact answer. I'd guess having WHERE on low cardinality column (such as bit or varchar2) makes impossible to use index even if it exists. Quite opposite with datetime column which I expect to have way higher cardinality. Even without index SQLServer may have statistics on this column which causes choosing much better and faster execution plan.
Mar
13
comment Inheritance of unknown type at creation time
Not sure if there is an online version, but search for "The Data Model Resource Book" by Len Silverston.
Mar
13
comment Inheritance of unknown type at creation time
Party-Role-Relationship is one of the patterns that will do the job. "Plumber", "Carpenter", etc are all roles that each person may be assigned to for a certain period of time .
Mar
12
awarded  Explainer
Mar
12
answered Single-row subquery returns more than one row
Mar
12
revised Single-row subquery returns more than one row
code formatting
Mar
6
comment sql taking < 1 sec to run in sql developer, 37 on the application side
@Sebas: I'd first try replacing bind variables with literals (for this particular query) in application if it's possible. The query doesn't look like it's supposed to get executed too often, so it might be ok for your system. Secondly, you can create outline for this query. Another option is to optimize the statement with DBMS_SQLTUNE or DBMS_ADVISOR packages either directly or through EM.
Mar
5
comment sql taking < 1 sec to run in sql developer, 37 on the application side
@Sebas: When you run it from SQLDeveloper with replaced placeholders execution plan is very likely different compared when it's running from application - you are using bind variables in the app (which is considered good practice), and literals in SQLDeveloper. But your query is quite complex with lots of bind variables (and possibly data skew) which can cause optimizer pick a wrong plan and stick to it - especially if you're running Oralce prior to 11g (11g and higher somehow improved bind peeking)
Mar
5
comment sql taking < 1 sec to run in sql developer, 37 on the application side
What is value for cursor_sharing parameter ?
Feb
25
answered Check attribute table referenced foreign key
Feb
20
awarded  Popular Question
Feb
18
comment How long does it take before an index on table makes a difference?
@Aaron Bertrand: I cannot agree that non-covering index is useless for SELECT *(or maybe I just misunderstood you). If it's selective enough, index seek or range scan + lookup will be faster than full table scan.
Feb
10
answered Sql Rank for records contain multiple combinations
Feb
5
answered SELECT WHERE CASE
Feb
4
comment Is a clustered index on a child table in a parent/child relationship the most optimal index?
Why do you think clustered index must be unique?