ThatJeffSmith

Tag: index

Modeling Function Based Indexes in Oracle

@thatjeffsmith Is there a way to define a function-based index in #SQLDevModeler? — Kent Graziano (@KentGraziano) October 29, 2014 Function based indexes [DOCS] have been part of Oracle Database since at least version 8. Instead of just indexing someone’s name, you could also index the values returned by a function call over that name. Example […]

SQL Server VS Oracle: Index Monitoring

Jealousy is not an emotion I generally feel for the SQL Server technology stack. I covet their Twitter camaraderie, but I ‘know’ that Oracle can counter just about anything thrown at it. People that Helped Me with this Post I was reminded that even old dogs can be taught new tricks while monitoring the #SQLSaturday […]

Toad for Oracle Tip: Custom Queries

There are SO many little nuggets in Toad that you can take advantage of. To list all of them would be a daunting task. Here’s one that you may have overlooked, Custom Queries. If you right-mouse-click on an object in the Schema Browser, you’ll see a list of operations you can perform. Take a second […]