検索

ディスカッション (6)1
続けるにはログインするか新規登録を行ってください
質問
· 2021年9月5日

how to optimize a SQL query using Query plan

#SQL #Caché #InterSystems IRIS

Hello everyone

 

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. 

I want to know what will be the answer for how to optimize SQL query in cache. 

Thanks in advance!!

2 Comments
ディスカッション (2)1
続けるにはログインするか新規登録を行ってください
質問
· 2021年9月5日

When to Use which kind of Method

#ObjectScript #Caché #InterSystems IRIS

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). 

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.

3 Comments
ディスカッション (3)1
続けるにはログインするか新規登録を行ってください
ディスカッション (0)1
続けるにはログインするか新規登録を行ってください
お知らせ
· 2021年8月23日

Meet the winners of the 1st Tech Article Contest!

#開発者コミュニティ公式 #IRIS contest

Hey Community,

Our first InterSystems Tech Article contest is over. Lots of new content to read: 23 amazing articles 🔥

Big thank you to everyone who participated in our writing competition!

And now it's time to announce the winners... excited?

Meet the 1st Tech Article contest winners and their articles:

⭐️ Expert Awards – winners selected by InterSystems experts:

🥇 1st place: BILLIONS - Monetizing the InterSystems FHIR® Accelerator Service with Google Cloud's Apigee Edge written by @sween

🥈 2nd place: Learning Path for beginners written by @Yuri Marx 

🥉 3rd place: InterSystems IRIS REST Application Patterns written by @Yuri Marx 

⭐️ Community Award – winner selected by Community members, article with the most likes:

🎉 Winner: Let's fight against the machines! written by @Henry Pereira

⭐️ And let's meet some authors who contributed a number of articles to this competition:

WOW! For their great contribution, we'd like to reward these authors with a 🎁 Nike Utility Speed Backpack 🎁! 

⭐️ Let's congratulate all our heroes at community.intersystems.com/contests/1:

THANK YOU ALL! You have made an incredible contribution to our Dev Community! 

P.S. The prizes are in production now. We will contact all the participants when they are ready to ship - stay in touch!

So,

Awesome 1st Tech Article contest, isn't it?

Thanks to all the participants for the efforts you pay in our 1st exciting writing contest!

And what's next.....?

Stay tuned for the next InterSystems Tech Article contest 😉

7 Comments
ディスカッション (7)2
続けるにはログインするか新規登録を行ってください